What are three SQL keywords used to change or set someone?s
permissions?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between a fill factor of 100 and 0?
What is a rownum?
How many replicas are maintained for each sql azure db?
What is the use of “join” in sql server?
What stored by the model?
How do you size a resultset?
What is the importance of concurrency control?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
what is normalization? : Sql server database administration
How to call a function from a stored procedure in SQL Server ?
What information is maintained within the msdb database?
How do you handle datasets larger than 50 gb?
How to find Duplicate Records In table?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Explain cursor as data base object?