Home » RDBMS Server » Security » OS_ROLES and SYSTEM users
OS_ROLES and SYSTEM users [message #157972] Tue, 07 February 2006 10:13
landini
Messages: 2
Registered: February 2006
Junior Member
I am trying to create a new database using the initialization parameter OS_ROLES='TRUE'.
When I issue the following create statement
CREATE DATABASE testsic
USER SYS IDENTIFIED BY Hpdba
USER SYSTEM IDENTIFIED BY Hpdba

everything goes ok, but when I try to connect using the SYSTEM user, a message saying that it has't the create session privileges is displayed.

I would like any suggestions regarding the best way to use system users, roles and external roles: should system users be created as operating system users? Or, on the contrary, have I to grant manually to internal system database users all the privileges I need?
Thanks
Previous Topic: Connection of database - sql*plus to Forms 6i
Next Topic: forget sys and system password
Goto Forum:
  


Current Time: Fri Mar 29 04:43:07 CDT 2024