Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle list grants on package

SELECT grantee, privilege
  FROM dba_tab_privs
 WHERE owner = 'owner'
   AND table_name = 'object_name'		-- Package, procedure...
   AND privilege = 'EXECUTE'
Comment

PREVIOUS NEXT
Code Example
Sql :: how to check grants on a package in oracle 
Sql :: postgres regular expression replace 
Sql :: select random sql 
Sql :: sql left characters 
Sql :: SQL NOT BETWEEN Operator 
Sql :: print hello world in plsql 
Sql :: What is dialect for Postgres 
Sql :: how to drop a unique constraint in sql 
Sql :: full sql mode 
Sql :: Cast for print sql 
Sql :: how to inner join 4 tables in sql 
Sql :: delete database mysql command 
Sql :: update join sql 
Sql :: postgresql function 
Sql :: sql escape quote 
Sql :: sql create database 
Sql :: mysql timestamp format 
Sql :: with postgres 
Sql :: postgress connection refused 
Sql :: mysql remove auto increment 
Sql :: set value to null sql 
Sql :: query by column for substring sql 
Sql :: Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF 
Sql :: drop CHECK constraint sql 
Sql :: object dependencies in oracle 
Sql :: nosql vs sql 
Sql :: inner join 
Sql :: encrypt and decrypt in sql server 
Sql :: postgres role does not exist 
Sql :: psql no such file or directory 
ADD CONTENT
Topic
Content
Source link
Name
5+8 =