With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.
SELECT LPAD (' ', 2 * LEVEL)
|| granted_role "User, his roles and privileges"
FROM (SELECT NULL grantee, username granted_role
WHERE username LIKE UPPER ('%&enter_username%') --<<---- ENTER USER NAME
SELECT grantee, granted_role
SELECT grantee, PRIVILEGE
START WITH grantee IS NULL;
Open in new window
CREATE OR REPLACE TRIGGER prevent_exp_imp
AFTER LOGON ON DATABASE
IF USER = 'SCOTT' ----<----user name to restrict
AND UPPER (SYS_CONTEXT ('userenv', 'module')) IN ('EXP.EXE', 'IMP.EXE')
'You are not allowed to export or import data.'
The revolutionary project management tool is here! Plan visually with a single glance and make sure your projects get done.