Database Privileges for Reverse Engineering

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Reverse Engineering an Existing Database

For SQL Server you need to ensure that you have SELECT privileges on the following system tables:

  • master.dbo.sysmessages
  • master.dbo.syslanguages
  • master.dbo.syslogins
  • master.dbo.sysremotelogins
  • master.dbo.sysservers
  • master.dbo.sysdatabases
  • master.dbo.sysprocesses
  • master.dbo.sysdevices
  • master.dbo.spt_values
  • master.dbo.sysoledbusers
  • master..sysxlogins
  • master.dbo.syssrvroles
  • master.dbo.sysloginroles
  • master.dbo.sysconfigures
  • master.dbo.sysusages
  • master.dbo.sysdevices
  • sysforeignkeys
  • sysprotects
  • sys.views
  • sysindexkeys
  • sysalternates
  • syskeys
  • syslogs
  • sysfiles
  • sysmembers
  • systhresholds

See Also