Help - Search - Members - Calendar
Full Version: Several people have priviledge to one schema
Oracle DBA Forums > Oracle > Oracle Forum
kensington
In our Oracle 9i Database we have a Project that uses one Schema called ProjectOne where several people need to be able to create tables, create,edit and delete records, create and delete triggers and sequences in the ProjectOne schema.

Our DBA creates a user account for each person where each person has their own username and password with priviledges to the ProjectOne Schema. The DBA doesnt want us to use the ProjectOne Schema username and password. Is this a standard practice with Oracle where each person needs their own username and password to login into the Database and view and edit one Schema (ProjectOne)?
andrew kerber
Its a pretty standard thing to do. The easiest solution is to have the dba create the objects or only give the password to one person on the team and have her create all the objects.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.