set echo off
set verify off
--
--  showuser_privs.sql    
--
--  Show all privileges for a specific user:
--		1. Roles granted
--		2. System privileges granted
-- 	3. Object privileges granted
--  Usage: @Showuser_privs username
--
set pagesize 30
--
define lsize=200
set linesize &&lsize
--
-- roles granted
select * from DBA_ROLE_PRIVS where grantee = upper('&&1');
-- system privileges granted
select * from DBA_SYS_PRIVS where grantee = upper('&&1');
-- object privileges granted
select * from DBA_TAB_PRIVS where grantee = upper('&&1');
set verify on
set echo on