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
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?
Can we add a cpu to sql server?
What are trace flags?
What is the difference between a "where" clause and a "having" clause?
What do you mean by a dependent functionality in a build?
How can I create a report based on a query? : sql server management studio
when you create a database how is it stored? : Sql server database administration
What is 2nf normalization?
Can you tell me about the concept of ER diagrams?
Do you know how to make remote connection in database?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?