Skip to Main Content
Forums

SQL & PL/SQL

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!

ORA-01955?

544789Nov 18 2006 — edited Nov 19 2006
Hi to everybody,
I wrote the following syntax to to enter the following ALTER USER statements to modify the list of default roles for the new HANDSONXE_USER2 user account:

SQL> ALTER USER handsonxe_user2
2 DEFAULT ROLE handsonxe_appuser;
ALTER USER handsonxe_user2
*
ERROR at line 1:
ORA-01955: DEFAULT ROLE 'HANDSONXE_APPUSER' not granted to user

thanks,
josh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2006
Added on Nov 18 2006
1 comment
2,401 views