Roles and Permission table in SQL 2000

FAQ

Profile

Roles and Permission table in SQL 2000

Database Help (Home) -> Security

Next: Query on several bases

Author

Message

Munish Narula

External

Since: Mar 12, 2008
Posts: 10

(Msg. 1) Posted: Fri Nov 21, 2008 3:03 am Post subject: Roles and Permission table in SQL 2000 Archived from groups: microsoft>public>sqlserver>security (more info?)

Hi, In SQL 2005 there is sys.database_principal and sys.database_permissions table from where i can see the roles and their permissions. But these tables are not present in SQL 2000. Which is the table from where i can get the information about the roles and the permission given to that role in SQL 2000. >> Stay informed about: Roles and Permission table in SQL 2000

Display posts from previous:

Related Topics:

permission issues with database roles - Hello, Does somebody knows or have a complete solution, for resolving the following issues when moving or copying a database to another sql server? - when attaching the moved database, i have orphan users. I can use the sp_help_revlogin to re-create..

Revoke Table, Grant Execute on Proc, but still get Permiss.. - All, I'm using SQL 2000 and have: * created a role * granted execute to my procs for that role * revoked on tables being accessed via the procs * added my db user to the role When I try to exec the procs, I get problems accessing the underlying tables....

sql 2008 and database roles are they ok to use - I read in a document from sql 2005 that database roles were going to be done away with in future reelases of sql but sql 2008 still has database roles. I like the idea of using a database role and assiging usrers to the role for security setup. But...

SQL Server Login and CRM Roles - I'm trying to link to SQLServer instance that is hosting CRM database. I need a login that allows me to access the 'filtered' CRM views. CRM needs to be able to associate the SQL Login with an Active Directory entry for a CRM user with appropriate..

What type of Server Roles to assign for Backup and Recovery - Hi there, I have a question , what is the best practice to create a login to perform backup and recovery, Can I just have DB role as DB_backupoperator or I have to assign a sysadmin role to the user ( in SQL authentication/ windows).Coming up with a....

	Database Help (Home) -> Security	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum