Re: [?] Schemas, Namespace, and Projects

Hi Brad,

    Since I am the DBA (ha ha ha) I wrote a script I named newuser.sql which my users (the ones who have to create projects) call with the project name -- to be used as the username and a password. The script then creates a tablespace and the user. It then makes the grants.

regards

Jerry

Bradley G. Smith wrote in message ...
>On Tue, 01 Sep 1998 15:43:34 GMT, Jerry Gitomer wrote:
>
>:> I run everything in a single Oracle instance. For each project I
 create
>:>a user who owns the project and has its own tablespace and datafiles (I
 am
>:>running on AIX and use JFS rather than raw partitions). At the time
 tables
>:>are created for the projects, under the projects userid the necessary
>:>permissions are granted to the appropriate subset of our standard user
>:>accounts.
>:>
>:> When the project is completed I am then able to export the user and
 then
>:>drop the tablespace including contents and delete the datafile. This
>:>simplifies management of projects -- a major consideration since at any
 one
>:>time we have over 100 projects, almost all of which will be completed
 within
>:>less than a year.
>
>Thanks for the suggestion Jerry. I will run this past our DBA. It
>seems that this would involve the DBA to create a user account. I
>would prefer to have this all managed by the project "owners" or
>participants via JDBC. But that may not be possible. We run Oracle on
>AIX and also use DFS.
>
>Brad Smith
>
>
>
>
Received on Thu Sep 03 1998 - 00:00:00 CDT