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.

Mysql: execute command denied to user ''@'localhost' for routine error

i got some problem during open my old website. My dataTable show: DataTables warning: JSON data from server could not …

mysql mysql-error-1064 privileges grant
Oracle - How to grant to a user the rights to another user's objects

I need to give to user TARGETUSER the rights to select/insert/update to all tables of user SOURCEUSER (I …

oracle permissions grant
Why is GRANT not working in MySQL?

I'm scratching my head on this one as I see a ton of helper websites showing how to create MySQL …

mysql grant
Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)

I have a MySQL user called dump with the following perms: GRANT USAGE ON *.* TO 'dump'@'%' IDENTIFIED BY ... …

mysql database mysqldump database-backups grant
Grant all privileges to user on Oracle schema

Is there a way to grant all privileges to a user on Oracle schema? I tried the following command but …

oracle database-schema grant
How can I grant only READ access to a Single table in Sql Server Database

I want to provide only READ access to a single table in SQL Server Database for a given user - …

sql-server grant user-roles
SQL Server : can you limit access to only one table

I think the answer is no but I'm looking to give someone access to a SQL Server database but I …

sql-server permissions sql-server-2016 grant
How can I give to user, execute another users's functions?

I want to give privileges to a user to call a function another users function. I write this : GRANT EXECUTE …

oracle privileges grant
How to grant all privileges on views to arbitrary user

How do you grant read/select access on all functions and views to an arbitrary user? I use psql --user=…

sql database postgresql grant pgadmin
GRANT with database name wildcard in MySQL?

I want to create a user 'projectA' that has the same permissions to every database named 'projectA_%' I know …

mysql syntax permissions grant