Re: Create Role System Priviledge
From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 29 Jan 2003 17:24:36 -0800
Message-ID: <1b061893.0301291724.3a983d22_at_posting.google.com>
Date: 29 Jan 2003 17:24:36 -0800
Message-ID: <1b061893.0301291724.3a983d22_at_posting.google.com>
Look in view DBA_SYS_PRIVS to see if "CREATE ROLE" was not assigned to any other role (select * from DBA_SYS_PRIVS where privilege = 'CREATE ROLE'). This was tested on my Oracle 8.1.6.
Daniel Received on Thu Jan 30 2003 - 02:24:36 CET