What are three SQL keywords used to change or set someone?s
permissions?

Answers were Sorted based on User's Feedback



What are three SQL keywords used to change or set someone?s permissions?..

Answer / shraddha

The three SQL keywords are grant ,revoke and deny.

Is This Answer Correct ?    23 Yes 2 No

What are three SQL keywords used to change or set someone?s permissions?..

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 three SQL keywords used to change or set someone?s permissions?..

Answer / deepti

grant,revoke and third no ideaa

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More SQL Server Interview Questions

How do I open port 1433?

0 Answers  


What is index in an assignment?

0 Answers  


What is Service Broker in sql server 2012?

0 Answers   UGC Corporation,


What are transactions and its controls?

0 Answers  


Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,






select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  


Explain insert into select statement?

0 Answers  


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?

2 Answers  


How much does sql server 2016 cost?

0 Answers  


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?

0 Answers  


What are commonly used mssql functions in php?

0 Answers  


How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  


Categories