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

What is sql injection and why is it a problem? : sql server security

0 Answers  


What is @@rowcount in sql?

0 Answers  


what is nonclustered index

0 Answers  


What is relationship? What number of sorts of relationship are there?

0 Answers  


Magic Tables ?

2 Answers   Thomson Reuters,






What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  


How you can add messages to the nt event log from within a stored procedure?

0 Answers  


What are the various Isolation levels?

2 Answers   HP,


what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  


What is Data model and how to prepare a data model.?

1 Answers   TCS,


What is a trigger?

4 Answers  


Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,


Categories