Database Privileges for Reverse Engineering
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