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
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What is the command used to get the version of sql server?
write coding for importing sql data into a word excel...
What is truncate table?
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,
Can we create nonclustered index in a table without creating a clustered index
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What are the different types of collation sensitivity in sql server?
Tell me about Triggers?
Can coalesce return null?
How to enter comments in transact-sql statements?
How do you delete a trigger?
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)