Top "Grant" questions

GRANT is a SQL standard command that authorizes one or more users to perform an operation or a set of operations on an object.

Why is a "GRANT USAGE" created the first time I grant a user privileges?

I'm new to the admin side of DBMS and was setting up a new database tonight (using MySQL) when I …

mysql database privileges grant
Remove privileges from MySQL database

Before you think this is a duplicate question, I believe I have a unique, even if it is somewhat dim-witted, …

mysql ubuntu phpmyadmin privileges grant
Postgresql: error "must be owner of relation" when changing a owner object

What is the grant option/trick I need to give to the current user ("userA") to allow him to change …

postgresql grant
Query grants for a table in postgres

How can I query all GRANTS granted to an object in postgres? For example I have table "mytable": GRANT SELECT, …

sql postgresql grant
"IDENTIFIED BY 'password'" in MySQL

I often see in many MySQL tutorials that people use command IDENTIFIED BY 'password' both during user creation and granting …

mysql privileges grant
MySQL Stored Procedure Permissions

I am trying to give a user permission to run a stored procedure at the stored procedure level on a …

mysql stored-procedures permissions grant
MySQL/Amazon RDS error: "you do not have SUPER privileges..."

I'm attempting to copy my mysql database from an Amazon EC2 to an RDS: I successfully did a mysqldump of …

mysql amazon-ec2 amazon-web-services amazon-rds grant
Grant Select, Insert, Update to a Tablespace

I've got a lot of tables in a tablespace, nearly 100. I have to grant Select, Insert, Update privileges on all …

oracle select insert grant tablespace
grant select on view

somewhere along the way something is going wrong, and I can't seem to find out why. If this is already …

oracle select database-schema grant
Grant a user permission to only view a MySQL view and nothing else

This question was originally using MySQL 5.1.44, but is applicable to MySQL 8.0+ too. Let's say I have a table with records …

mysql view permissions database-permissions grant