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 do I edit a procedure in sql server?
how to trace the traffic hitting a sql server? : Sql server database administration
How to create a simple table to test triggers in ms sql server?
What are difference between Cluster index and Non-Cluster index?
Explain having clause?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
In which tcp/ip port does sql server run? Can it be changed?
how to overcome kernel isssues
How to assign null values to variables or columns?
What is the purpose of self join?
How to make a column nullable?
How to name query output columns in ms sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)