The account with Administrator privilege can only provide privileges for table in two manners,
- GRANT
- REVOKE
SQL GRANT Command
SQL GRANT is a command used to provide access or privileges on the database objects to the users.SYNTAX:
GRANT privilege_name
ON object_name
TO {user_name |PUBLIC |role_name}
[WITH GRANT OPTION];
privilege_name is the access right or privilege granted to the user. Some of the access rights are ALL, EXECUTE, and SELECT.
object_name is the name of an database object like TABLE, VIEW, STORED PROC and SEQUENCE.
user_name is the name of the user to whom an access right is being granted.
user_name is the name of the user to whom an access right is being granted.
PUBLIC is used to grant access rights to all users.
ROLES are a set of privileges grouped together.
WITH GRANT OPTION - allows a user to grant access rights to other users.
SQL REVOKE Command:
The REVOKE command removes user access rights or privileges to the database objects.SYNTAX
REVOKE privilege_name
ON object_name
FROM {user_name |PUBLIC |role_name}
0 Comments:
Post a Comment