Commands in SQl [message #680738] |
Fri, 05 June 2020 03:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/223b4d05ba9d882c578afb6ac4207c16?s=64&d=mm&r=g) |
aartiyadav
Messages: 1 Registered: June 2020
|
Junior Member |
|
|
Hello Everyone, I am in this community and I am in learning face for SQL, I want to know some DCL command syntax for GRANT and REVOKE. Can anyone suggest me some reference where I can check and do the practice of this command?
|
|
|
|
|
|
Re: Commands in SQl [message #681029 is a reply to message #681027] |
Mon, 08 June 2020 09:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68658 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
singhjjyoti0399 wrote on Mon, 08 June 2020 14:46Here is the syntax for both of the DCL Commands
1. GRANT Command
GRANT privilege_name
ON object_name
TO {user_name |PUBLIC |role_name}
[WITH GRANT OPTION];
2. Revoke Command
REVOKE privilege_name
ON object_name
FROM {user_name |PUBLIC |role_name}
This is a very specific case for these statements.
Have a look at the documentation for the complete syntax and features of these commands.
[Updated on: Mon, 08 June 2020 09:57] Report message to a moderator
|
|
|