Execute is granted to PUBLIC on the
related DBMS_ZHELP_IR
GET_OBJECT_GRANTS
Returns information on one user granted privileges on the designated
object.
When STAT = TRUE repeated calls return the same user. When STAT = FALSE
cycles through the users who have privileges on the designated object.
Overload 1
dbms_zhelp.get_object_grants(
OBJ_ID IN NUMBER,
CASCADE IN BOOLEAN,
GRANTOR OUT VARCHAR2,
GRANTEE OUT VARCHAR2,
GRANT_OPTION OUT BINARY_INTEGER,
PRIV OUT
NUMBER,
OBJ_SCHEMA OUT VARCHAR2,
OBJ_NAME OUT VARCHAR2,
STATE IN OUT BOOLEAN);
conn uwclass/uwclass
GRANT select ON servers TO hr;
GRANT select ON servers TO scott;
GRANT select ON servers TO sh;
conn / as sysdba
SELECT object_id
FROM dba_objects
WHERE object_name = 'SERVERS'
AND owner = 'UWCLASS'
AND object_type = 'TABLE';
dbms_zhelp(
OBJ_SCHEMA IN VARCHAR2
OBJ_NAME IN VARCHAR2,
OBJ_CLASS IN NUMBER,
CASCADE IN BOOLEAN,
GRANTOR OUT VARCHAR2,
GRANTEE OUT VARCHAR2,
GRANT_OPTION OUT BINARY_INTEGER,
PRIV OUT NUMBER,
STATE IN OUT BOOLEAN);
Object
Class
Name
1
index
2
table
3
cluster
4
view
6
sequence
7
procedure
8
function
9
package
13
type
conn uwclass/uwclass
GRANT select ON servers TO hr;
GRANT select ON servers TO scott;
GRANT select ON servers TO sh;