Breaking News: Grepper is joining You.com. Read the official announcement!

oracle privileges users

Add Answer

VasteMonde answered on January 20, 2021 Popularity 9/10 Helpfulness 4/10

answer oracle privileges users

related grant all privileges oracle user

related oracle user privileges

related Oracle privileges

oracle privileges users

Comment

SELECT USERNAME,
       LOCK_DATE,
       EXPIRY_DATE
FROM DBA_USERS
WHERE USERNAME IN (SELECT GRANTEE
                   FROM DBA_SYS_PRIVS
                   WHERE PRIVILEGE = 'UNLIMITED TABLESPACE')
ORDER BY USERNAME;

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: oracle privileges sql

Link to this answer
Share Copy Link

Contributed on Sep 12 2021

VasteMonde

0 Answers Avg Quality 2/10

Closely Related Answers

grant all privileges oracle user

Comment

GRANT ALL PRIVILEGES TO USER_NAME;

Popularity 9/10 Helpfulness 9/10 Language sql

Source: www.oracletutorial.com

Tags: oracle or

Link to this answer
Share Copy Link

Contributed on Nov 19 2022

TNmiko

0 Answers Avg Quality 2/10

oracle user privileges

Comment

-- List privileges, including roles, for my_user
SELECT GRANTEE, PRIVILEGE AS PRIVILEGE_ROLE,
       NULL AS OWNER, NULL AS TABLE_NAME, NULL AS COLUMN_NAME,
       ADMIN_OPTION AS PRIVILEGE, 
       NULL AS GRANTABLE
FROM DBA_SYS_PRIVS WHERE GRANTEE = 'my_user'
UNION ALL
SELECT r.GRANTEE, r.GRANTED_ROLE AS PRIVILEGE_ROLE, p.OWNER, p.TABLE_NAME, 
	p.COLUMN_NAME, PRIVILEGE, p.GRANTABLE
FROM DBA_ROLE_PRIVS r LEFT JOIN ROLE_TAB_PRIVS p ON p.ROLE = r.GRANTED_ROLE
WHERE r.GRANTEE = 'my_user';

Popularity 10/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: list

Link to this answer
Share Copy Link

Contributed on Jan 20 2021

VasteMonde

0 Answers Avg Quality 2/10

Oracle privileges

Comment

DELETE data from a specific table.
	INSERT data into a specific table.
	CREATE a foreign key reference to the named table or to a subset of columns from a table.
	SELECT data from a table, view, or a subset of columns in a table.
	CREATE a trigger on a table.
	UPDATE data in a table or in a subset of columns in a table.
	RUN a specified function or procedure.
	USE a sequence generator or a user-defined type.

Popularity 7/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: oracle privileges sql

Link to this answer
Share Copy Link

Contributed on Aug 25 2022

Blue-eyed Badger

0 Answers Avg Quality 2/10

oracle privileges users

Contents

More Related Answers

oracle privileges users

Closely Related Answers

grant all privileges oracle user

oracle user privileges

Oracle privileges

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.