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 do you mean by table and field in sql?
How can windows applications connect to sql servers via odbc?
what is the different types of backups available in sql server? : Sql server database administration
How to create a login account in ms sql server to access the database engine using "create login" statements?
Explain error and transaction handling in sql server?
What is difference between count (*) and count 1?
What is the xml datatype?
Explain time data type in sal server 2008?
what is extended StoreProcedure ?
Write a SQL Query to find first Week Day of month?
What is the difference between login and a user?
13 Answers CTS, TCS,
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?
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)