| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
