Sql

SELECT grantee, privilege_type 
FROM information_schema.role_table_grants 
WHERE table_name='mytable'

select * from information_schema.role_table_grants where grantee='<user>';

PREVIOUS	NEXT

Code Example
Sql :: how to delay stored procedure execution in sql server
Sql :: sql eliminare un record
Sql :: sql server find all foreign keys that reference a column
Sql :: check all sequences oracle sql
Sql :: oracle extract minute from date
Sql :: oracle drop chain step
Sql :: install mysql powershell
Sql :: oracle alter sequence nextval
Sql :: mysql password error create datbase
Sql :: sql server reset auto increment
Sql :: ifnull postgres
Sql :: postgres set user as superuser
Sql :: get month of date sql
Sql :: get all records who register today in mysql
Sql :: mysql where in array
Sql :: vagrant mysql downgrade version
Sql :: foreign key oracle
Sql :: mysql remove definers
Sql :: oracle nls instance
Sql :: display users in mysql
Sql :: integer limit sql create table
Sql :: oracle apex who is connected
Sql :: query string starts with vowels
Sql :: mysqldump password
Sql :: sql sample tables with data
Sql :: row number mysql
Sql :: oracle trace session
Sql :: postgres date difference seconds
Sql :: copy sql table to new table
Sql :: adding indexing on a db model in mysql using sequelize