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 to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
How do you send email on SQL Server?
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance
What is the beast way to write CTE in SQL Server ?
How do I find the sql server instance name?
How does using a separate hard drive for several database objects improves performance right away?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Difference between report and query parameter. Why do we need different type of parameter?
How to find the second highest salary of an employee?
What is indexed views? plz explain with example?
What are a scheduled jobs or what is a scheduled tasks?
What does executeupdate return?
Oracle (3253)
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)