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

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

Question Posted / guest

3 Answers
15396 Views
I also Faced
E-Mail Answers

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

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers

What command is used to delete a table from the database in the sql server and how?

0 Answers

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

1 Answers United Healthcare,

What is the boxing and unboxing concept in .net?

0 Answers

How to get all stored procedures in sql server?

0 Answers

What are types of storage modes? : sql server analysis services, ssas