The permissions are usually attached to a role named arole_<servername> (7.x anyway) and the user granted that role.
-- Create the role create role AROLE_server; -- Grant/Revoke system privileges grant alter session to AROLE_server; grant create cluster to AROLE_server; grant create database link to AROLE_server; grant create procedure to AROLE_server; grant create sequence to AROLE_server; grant create session to AROLE_server; grant create synonym to AROLE_server; grant create table to AROLE_server; grant create trigger to AROLE_server; grant create view to AROLE_server; grant query rewrite to AROLE_server; -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 Joe DeSouza <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 04/24/2008 01:49 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Default Roles, System Privileges etc needed for aradmin user on Oracle ** I was looking for that too but couldn't find it.. In any case I don't think I need the information as I got a dump file from a prod box that contains the user information in the dump too so it will restore the user information when I import.. Thank you anyways.. Joe ----- Original Message ---- From: William H. Will Du Chene <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, April 24, 2008 2:07:58 PM Subject: Re: Default Roles, System Privileges etc needed for aradmin user on Oracle If you're installing on a *nix box, there should be a .sql or .ora file in the installation directory (or the package directory - it's been a while) that should contain the statements that are used to create the arsystem database. I am not sure, but I believe that the grant information might well be in there. > Could anyone who has installed the AR System over Oracle, using the AR > System installer to create the database on Oracle give me a list of all > the Roles and System Privileges that are granted to the aradmin user by > the installation script? > Are there any other settings for the aradmin user besides the Roles and > System Privileges that I must take care of before I start installing? I > have already defaulted the ARSYSTEM table space and the ARTEMP space > needed for this user. > Thanks for all your responses.. > Cheers > Joe > > > ____________________________________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > -- ------------------------------------- Will Du Chene ------------------------------------- [EMAIL PROTECTED] http://www.myspace.com/wduchene ------------------------------------- "...you're an anti-Microsoft zealot..." - Norm Kaiser ------------------------------------- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
