Permsssions to create sql profiles
From: <zigzagdna_at_yahoo.com>
Date: Thu, 5 Feb 2009 13:45:36 -0800 (PST)
Message-ID: <adf30d35-e2a3-4f24-9a92-572e80a1df42_at_v5g2000pre.googlegroups.com>
I am using Oracle 10.1 and 10.2 on Windows 2003 and HP UNIX 11i platforms.
When I need to create sql profiles, it works if I login with dba privileges. However, for some databases I do not have dba privileges. What are minimum privileges required. I read somewhere to be given advisor role. But, advisor role still gives some access errors. I know with stored outlines one did not need dba privileges; it should be true with sql profile as well. Received on Thu Feb 05 2009 - 15:45:36 CST
Date: Thu, 5 Feb 2009 13:45:36 -0800 (PST)
Message-ID: <adf30d35-e2a3-4f24-9a92-572e80a1df42_at_v5g2000pre.googlegroups.com>
I am using Oracle 10.1 and 10.2 on Windows 2003 and HP UNIX 11i platforms.
When I need to create sql profiles, it works if I login with dba privileges. However, for some databases I do not have dba privileges. What are minimum privileges required. I read somewhere to be given advisor role. But, advisor role still gives some access errors. I know with stored outlines one did not need dba privileges; it should be true with sql profile as well. Received on Thu Feb 05 2009 - 15:45:36 CST