My MS SQL Experience
I would like to share my experience on MSSql server
Monday 11 April 2011
How to retrieve table name and privilages of user in SQL server
Select
TABLE_NAME
,
PRIVILEGE_TYPE
from
INFORMATION_SCHEMA.TABLE_PRIVILEGES
where
GRANTEE
=
'Toolbox'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment