A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is trigger explain with program?

0 Answers  


What is extent? Types of extents?

0 Answers  


Explain about temporary stored procedure?

0 Answers  


What is the difference between for trigger and after trigger?

0 Answers  


Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  






What is table level trigger?

0 Answers  


What is triggers and its types?

0 Answers  


What are the different types of backups avaialabe in sql server 2005?

0 Answers  


How to name query output columns in ms sql server?

0 Answers  


What is statement level trigger?

0 Answers  


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

0 Answers  


What is data modeling and Reterminal integrity?

0 Answers  


Categories