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 are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,


What is the difference between the application object and session object?

0 Answers  


What is an example of a foreign key?

0 Answers  


How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,


What is cdc in sql server?

0 Answers  






if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,


How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,


What are the types of stored procedures in an sql server?

0 Answers  


What is a recursive stored procedure in sql server?

0 Answers  


to explain sql server 2000 architecture & authentication

1 Answers   HCL,


What is the difference between rank and dense_rank?

0 Answers  


Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  


Categories