Solved

grantee_principal_id in SQL 2000

Posted on 2010-08-23
2
504 Views
Last Modified: 2012-05-10
is the info about grantee_principal_id stored in any system views in SQL 2000?

thanks
0
Comment
Question by:anushahanna
2 Comments
 
LVL 41

Accepted Solution

by:
ralmada earned 500 total points
ID: 33502019
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
 
LVL 6

Author Comment

by:anushahanna
ID: 33502046
it is going to be a handy and helpful reference. Thanks ralmada.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now