Commands in SQl [message #680738] |
Fri, 05 June 2020 03:08 |
|
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 |
|
Michel Cadot
Messages: 68694 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
|
|
|