Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

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

What is SQL server agent?

2 Answers   HCL, SAP Labs,

What is the difference between ddl,dml and dcl commands?

0 Answers   BirlaSoft, Verifone,

In which files does sql server actually store data?

0 Answers  

What is role playing dimension with two examples? : sql server analysis services, ssas

0 Answers  

How to restore performance issues and how to check?

0 Answers  




How to connect to a sql server using odbc_connect()?

0 Answers  

sql server architecture ?

0 Answers  

What are functions in the sql server?

0 Answers  

How reterive duplicate value in SQL?

6 Answers  

How to enter binary string literals in ms sql server?

0 Answers  

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  

Define clusters?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories