Hi all
Is there a way to check the permissions given to all tables
in the database.
My Scenario is
There are 100+ tables in the database and less than 10
tables have been given Select permission access. I want to
find out which 10 tables have been given the SELECT
permission.
Any system stored procedure or script to find this.
Thanks in advance.
Anand.See
INFORMATION_SCHEMA.TABLE_PRIVILEGES
>--Original Message--
>Hi all
>Is there a way to check the permissions given to all
tables
>in the database.
>My Scenario is
>There are 100+ tables in the database and less than 10
>tables have been given Select permission access. I want
to
>find out which 10 tables have been given the SELECT
>permission.
>Any system stored procedure or script to find this.
>Thanks in advance.
>Anand.
>.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment