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
How we can refresh the view?
What is index, cluster index and nonclustered index?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
How to set database to be single_user in ms sql server?
What are the OS services that the SQL Server installation adds?
write the query for taking database backup in sql
10 Answers ABC, IBM, Logica CMG, MA,
What are the advantages of the mirroring?
What is partition, how will you implement it? : sql server analysis services, ssas
What the different topologies in which replication can be configured?
Explain important index characteristics?
What is the difference between the 2 operating modes of database mirroring?
What are the different types of columns types constraints in the sql server?