Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Please help! Oracle 10g repository creation quesiton

Re: Please help! Oracle 10g repository creation quesiton

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 15 Mar 2006 21:15:13 +0100
Message-ID: <dv9rrm$djf$1@news5.zwoll1.ov.home.nl>


packermantodd wrote:
> Tha nk you for your response!
>
> I looked through the ckcreate script, and showed our DBA, and the
> CREATE ANY <many objects> seemed very gratuitous to him. But that is
> not my primary concern just now (though it is for my DBA...).
>
> What I need to know is what permissions are needed (minimum) to execute
> the scripts that create the repository and repository admin, etc.
> (execute the ckcreate script, for example). My DBA needs to know what
> permissions to give my user account so I can create and configure this
> repository for testing.
>
> I hope that makes my question clearer.
>
> Thanks in advance for your response!
> -Todd
>

iirc ckuser.sql will provide the day-to-day Designer Repository user?

Again - the repository admin needs quite a lot of rights, as he is the object owner (as SYS would be in the RDBMS).

It's just as it is - don't see why the DBA would make a fuss about it - it's a development repository; not a production system!

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Wed Mar 15 2006 - 14:15:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US