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 is sql injection and why is it a problem? : sql server security
What is @@rowcount in sql?
what is nonclustered index
What is relationship? What number of sorts of relationship are there?
Magic Tables ?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
How you can add messages to the nt event log from within a stored procedure?
What are the various Isolation levels?
what is the basic diffrence betn a col declared in char(1) and in varchar(1)
What is Data model and how to prepare a data model.?
What is a trigger?
Can we rewrite subqueries into simple select statements or with joins? Example?