-
Hi DBAs
I am having the above mentioned error when I am connecting as SYS. this is bcos I run a script that gave lot of rules to sys instead of that user.
Is it possible to drop SYS and recreate SYS running some scripts
Help me out and thanks in advance
-
no it si not possible to drop user sys as he owns the data dictonary tables.post your error message and not just the eerrir number
-
hi
The actual error is I am exceeding the roles
THe err no ora-01925 tells maximum of 20 enabled roles exceeded.
So I can't log into sys. How to solve this problem.
I know that I cannot remove sys but is there any script to overright the user with prev. / Original rights
Thanks
-
change the ini.ora parameters your problem would be solved
hth
-
Hi hth
I solved the problem by setting the init parameter like this.
Init.ora
max_enabled_roles = 50
Shutdown
Startup
Connect sys/*******
done
Thanks and Oracle Help also states the same
-
hi there
there si one small goof you made hth means hope this helps
my name is hrishy anyway
hth