Top "Grant" questions

How to Grant REFERENCES permission to all tables

I have to grant REFERENCES permission to a login say sql_login. I can give grant REFERENCES permission to individual …

sql sql-server grant

User Granted Access to Stored Procedure but Can't Run Query

I am working on a product that runs an SQL server which allows some applications to login and their logins …

sql sql-server stored-procedures database-permissions grant

grant trigger to schema not working

I need to give an user TRIGGER permission for an whole schema in mysql to import mysql workbench backup. I …

mysql grant

SQL grant execute on multiple objects

Hi all I want to add execute permissions to a user for multiple objects. But I can't seem to add …

database sql-server-2008 grant

Grant Execute Function permission to another user

I have a database function fn_relation_isModerator, only user api has access to this function. Now I want another …

mysql stored-procedures grant database-permissions

Grant privileges on MariaDB

I'm trying to grant privileges for user on MariaDB 10, but I've got an error 1045 [root@lw343 ~]# mysql -u root -p …

sql root mariadb grant mysql-error-1045

Postgresql: How to grant permission for set role?

There is user 'test_user1'. SET ROLE Command: SET ROLE test_user1 returns error: ERROR: permission denied to set …

postgresql role grant

Oracle Create View issue

I am logged in as the dba account and I want to create a view in User1's schema, but …

sql oracle view grant ora-00942

Query GRANTS granted to a sequence in postgres

To query GRANTS granted to a table I can use a query like: SELECT grantee, privilege_type FROM information_schema.…

sql postgresql sequence grant