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 |
How much memory that we are using in Logshipping Concept?
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?
Is Sql non procedural query language?
Give main differences between "Truncate" and "Delete".
How to update multiple rows with one update statement in ms sql server?
What do you mean by 'normalization'?
0 Answers Ernst Young, Thomson Reuters,
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?
What are the security related catalog views? : sql server security
List the different types of collation sensitivities in sql server?
What is the difference between substr and charindex in the sql server?
What is triggers and its types?
explain extended properties
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)