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

How we can refresh the view?

0 Answers  


What is index, cluster index and nonclustered index?

0 Answers  


How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,


How to set database to be single_user in ms sql server?

0 Answers  


What are the OS services that the SQL Server installation adds?

3 Answers  






write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,


What are the advantages of the mirroring?

0 Answers  


What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  


What the different topologies in which replication can be configured?

0 Answers  


Explain important index characteristics?

0 Answers  


What is the difference between the 2 operating modes of database mirroring?

0 Answers  


What are the different types of columns types constraints in the sql server?

0 Answers  


Categories