RE: What privileges/roles are rquired to create a user
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <JDunn@xxxxxxxxx>, "oracle-l digest users" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Sep 2010 08:30:08 -0400
The easiest way is to create the user as system connected normally.
Assuming you don't want to do that you then need an account in the
database with the dba role or the create user and grant any role system
privileges.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Dunn
Sent: Thursday, September 16, 2010 3:48 AM
To: oracle-l digest users
Subject: What privileges/roles are rquired to create a user
Currently whenever we create a new user and grant that user privileges
we do that as SYSDBA
We would prefer not to do this as SYSDBA
But what are the minimum privilege(s)/role(s) that a user needs to allow
that user to create new users and grant them privileges?
John
Other related posts:
