ora-01925 error

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