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 meant by sql injection with example and one more question how to catch the errors in sqlserver
What command do we use to rename a db, a table and a column?
Which tcp/ip port does sql server run on? How can it be changed?
What is the appropriate number of test cases that you can write on a database?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
Can you tell me some of the common replication dmv's and their use? : sql server replication
How to set database to be read_only in ms sql server?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Is sql server difficult to learn?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What are the different index configurations a table can have?
Explain couple pf features of 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)