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

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  


Can we add a cpu to sql server?

0 Answers  


What are trace flags?

0 Answers  


What is the difference between a "where" clause and a "having" clause?

0 Answers  


What do you mean by a dependent functionality in a build?

0 Answers   HCL,






How can I create a report based on a query? : sql server management studio

0 Answers  


when you create a database how is it stored? : Sql server database administration

0 Answers  


What is 2nf normalization?

0 Answers  


Can you tell me about the concept of ER diagrams?

0 Answers  


Do you know how to make remote connection in database?

0 Answers  


As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,


What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,


Categories