Grant syntax in sql

Grant sql

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.

Source: grepper.com

Grant sql

For example, suppose user JONES needs to use the Change mode 
of the Table Editor for a table called ORDER_BACKLOG. 
To grant JONES the UPDATE privilege on the ORDER_BACKLOG table, 
issue the following statement:

GRANT UPDATE ON ORDER_BACKLOG TO JONES WITH GRANT OPTION

Source: grepper.com

Sql grant

--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.
  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.
  PUBLIC is used to grant access rights to all users.
  role_name are a set of privileges grouped together.
  WITH GRANT OPTION - allows a user to grant access rights to other users.
  
  Ex.
  GRANT SELECT ON table1 TO user1;

Source: grepper.com

Similar codes

5 votes267 views1 answer
Migrate sql table another database
SQL
0 vote194 views1 answer
Sql server check whether column has same equal values
SQL
0 vote192 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
-1 vote192 views2 answers
Postgres autoincrement primary key
SQL
0 vote200 views1 answer
Sql select all tables from database change url
SQL
4 votes194 views1 answer
To date oracle with time
SQL
3 votes197 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
1 vote254 views1 answer
Sample clause in sql
SQL
0 vote224 views2 answers
Jsonb
SQL
0 vote242 views1 answer
Postgresql import data from csv
SQL