Which system tables contain information on privileges granted and privileges o

Which system tables contain information on privileges
granted and privileges obtained

Question Posted / guest

Which system tables contain information on privileges granted and privileges obtained..

Answer / naresh

USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECDsystem tables
contain information on privileges gran...

Is This Answer Correct ?

8 Yes

4 No

More SQL Server Interview Questions

What are the advantages of passing name-value pairs as parameters?

How to list all dsn entries on your local machine using odbc_data_source()?

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

What is update locks?

what is the difference between Delete and Truncate

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

What is a self join in sql server?

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

What is Report Server,Report Manager and Report Builder in SSRS 2005?

What is default constraint in ms sql server?

What is pivot and unpivot?

What are the differences between lost updates and uncommitted dependencies?

For more SQL Server Interview Questions Click Here