table access - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

table access

Author

Topic

priyaram
Yak Posting Veteran

82 Posts

Posted - 2005-08-08 : 15:53:02

is there any stored procedure to check what user is having what access rights on what tables??

thanks in advance

X002548
Not Just a Number

15586 Posts

Posted - 2005-08-08 : 15:59:50

Look at the system tables in Books online

SELECT * FROM syspermissions

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2005-08-08 : 16:17:15

You can also use the information schema:

SELECT PRIVILEGE_TYPE, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES
WHERE GRANTEE = [REPLACE WITH A USER]

Daniel
SQL Server DBA
www.dallasteam.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources