|
-
create another user, never use SYS or SYSTEM, you dont even need to gran DBA to the new user. As long as the new user is the owner of the tables he can grant the privileges on his tables to other users, you dont need DBA to create objects
After you create the new user simply do
grant connect, resource to newuser;
connect and resource are roles (group or set of privileges whatever you want to call them, DBA is also a role), mostly these two roles are more than enough, if the user requires more privilege you can grant the privileges individually
And make sure you create tablespaces before create the users and assign these new tablespaces to the new user or users so when they create the objects the new objects reside in these new tablespaces
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|