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 advantages of using stored procedures?
What are the different acid properties?
How to delete the duplicate rows from a table in SQL Server ??
What are mdf,ndf,ldf files and how to see the data in those files?
What is ms sql server triggers?
What are the different normalization forms?
What is the difference between OLEDB and ODBC
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What the different components in replication and what is their use?
How to insert multiple rows with a subquery?
What is the use of CASCADE CONSTRAINTS?
What do you mean by an execution plan? Why is it used?
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)