What are three SQL keywords used to change or set someone?s
permissions?
Answers were Sorted based on User's Feedback
Answer / shraddha
The three SQL keywords are grant ,revoke and deny.
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / trived.r
this used to changes the permissions on database
this DCL(DATA CONTROL LANGUGE)STATEMENT
*)GRANT---THIS IS ACCESS GARANTED ON PARTICLUR DB OR
USER
*)DENY----THIS IS PARTICLUR USER WAITING FOR ACCESS WHILE
TME WHEN COMMETED THE DATA THEN PERMISSION ON DB
*)REVOKE--- THIS STATEMENT USE THE USER HAVE NO PERMISIONS
| Is This Answer Correct ? | 11 Yes | 2 No |
what are the Prerequisites for Replication?
what is meant by deafult in sql server?
Explain active/passive and active/active cluster configurations?
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.
is there a column to which a default can't be bound? : Sql server database administration
How to copy the tables, schema and views from one sql server to another?
Explain filestream storage of sql server 2008?
Can you get second highest salary from the table?
What is the use of MOVE keyword in restore command
What are exact numeric data types in ms sql server?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Tell me what is a linked 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)