Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

one user for multiple tablespaces

655260Jun 16 2009 — edited Jun 17 2009

Hello.

Oracle 11g enterprise.

Whenever I setup a new tablespace on my server, I create a user for each tablespace on the server.

Is is possible to create only one user for all tablespaces on a server?

What is the easiest way to create this one user to have all roles and privileges across all tablespaces?

Any suggestions are greatly appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 15 2009

Added on Jun 16 2009

#general-database-discussions

17 comments

2,535 views