Re: SYS vs. SYSTEM

> That's because it isn't a role at all, but a system privilege. Number 83 or
> 94 (memory fails me) in the select * from system_privilege_map.

I know. And that's what I was trying to point out, that it's not a role like other database roles. But I didn't want to confuse the poor chap. He was having difficulties with the differences between SYS and SYSTEM. And I wouldn't say to that individual that SYSDBA is a system privilege less he try to find it in DBA_SYS_PRIVS, where it isn't.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"