Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 592
  • Last Modified:

grantee_principal_id in SQL 2000

is the info about grantee_principal_id stored in any system views in SQL 2000?

thanks
0
anushahanna
Asked:
anushahanna
1 Solution
 
ralmadaCommented:
the equivalent to sys.database_permissions and sys.server_permissions views in SQL 2000 is the syspermissions table. And the column is "grantee"
The following link will help you to map SQL 2005 views to SQL 2000 tables.
http://msdn.microsoft.com/en-us/library/ms187997.aspx 
0
 
anushahannaAuthor Commented:
it is going to be a handy and helpful reference. Thanks ralmada.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now