Sql

Search

how to check grants on a package in oracle

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 :: sql sum by column
Sql :: add bool column in sql
Sql :: sql delete all values in a column
Sql :: postgresql append array
Sql :: if null mysql
Sql :: sql server case sensitive search
Sql :: oracle to_char number format percentage
Sql :: Get first 10 in sql
Sql :: sqlite save db
Sql :: how to delete the rows with null values in mysql
Sql :: mysql add column to table
Sql :: mysql trim spaces
Sql :: how to check if a column is null in sql
Sql :: oracle drop sequence if exists
Sql :: PSQL use LIKE with timestamps
Sql :: mysql grant select update insert delete
Sql :: spring boot working with sql database connection
Sql :: json with root element in sql server
Sql :: how to combine 2 tables in mysql
Sql :: postgres user permissions
Sql :: rename column in table sql
Sql :: firebase query timestamp
Sql :: oracle array
Sql :: WHERE not regex in SQL
Sql :: oracle object dependencies
Sql :: list table columns mysql
Sql :: sql convert datetime
Sql :: odd record sql query
Sql :: sql get character at index
Sql :: sql oracle update multiple rows

Search

SQL

how to check grants on a package in oracle

ADD CONTENT