I asked our IT department who admins our Unix Oracle installs to create me an Oracle user with DBA privileges so I connect to Unix Oracle, create my tablespace and do my thing.
The account unix_me was created and I can do the following
sqlplus > grant select on "SYS"."COL$" to different_user
I admin my own Windows Oracle install, I tried
sqlplus> create user me identified by mypass;
sqlplus> grant dba to me with admin option;
sqlplus> grant select on "SYS"."COL$" to different_user
This is presumably because 'unix_me' has grant select on any, or something and 'me' does not.
But my question is how do I tell what privileges/roles each user has so I can compare them?