• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 610
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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