What is the difference between grant and with grant while giving permissions to

What is the difference between grant and with grant while giving permissions to the user?

Question Posted / hiteshwar singh

1 Answers
1061 Views
I also Faced
E-Mail Answers

What is the difference between grant and with grant while giving permissions to the user?..

Answer / Firoz Dost

{"grant": "Grant allows you to give specific permissions to a user or role.n"with_grant": "With Grant indicates that the new permission should include all the privileges of the user who granted the permission. It is used when cascading permissions from one user to another."}

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL Server Interview Questions

What is sql server profiler?

1 Answers

What is de-normalization and what are some of the examples of it?

1 Answers

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers

what is memory-optimized nonclustered indexes

1 Answers

How will you monitor replication latency in transactional replication? : sql server replication

1 Answers

What are the different methods available under sqlcommand class to access the data?

1 Answers UGC Corporation,

What is user-defined inline table-valued function?

1 Answers

What is the difference between migration and upgradation in sql server?

1 Answers

How do you read transaction logs