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 do I open port 1433?
What is index in an assignment?
What is Service Broker in sql server 2012?
What are transactions and its controls?
Can we move Resource database from one path to another? If yes,How can we?
select top 5 * from emp order by newid() my question is , how this query get executed?
Explain insert into select statement?
if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?
How much does sql server 2016 cost?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are commonly used mssql functions in php?
How to Check Whether a Global Temporary Exists in a SQL Database or not?