Create or Drop user issue

[CassidyHunt]

Something changed in my database that I am unaware of. That change now impacts my ability to create and drop users. I can create and drop users just fine as long as I am using the sys account. The second I use my account that has been granted dba permissions I get the following error:

ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 23
ORA-06512: at line 33

I setup sql trace and the log file reports this as the problem:

PARSING IN CURSOR #2 len=210 dep=3 uid=0 oct=3 lid=0 tim=1459186226 hv=864012087 ad='a7891358'
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
END OF STMT
EXEC #2:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=3,tim=1459186224
FETCH #2:c=0,e=5,p=0,cr=2,cu=0,mis=0,r=0,dep=3,og=3,tim=1459186248
EXEC #8:c=0,e=4490,p=0,cr=24,cu=0,mis=1,r=0,dep=2,og=1,tim=1459186502
FETCH #8:c=0,e=1408,p=0,cr=0,cu=0,mis=0,r=27,dep=2,og=1,tim=1459187921
EXEC #1:c=31250,e=58422,p=6,cr=484,cu=0,mis=0,r=0,dep=1,og=1,tim=1459187978
ERROR #1:err=6502 tim=274716484
EXEC #3:c=140625,e=282266,p=34,cr=2627,cu=0,mis=0,r=0,dep=0,og=1,tim=1459188044
ERROR #3:err=604 tim=274716484

I do not know how to use this information. I have set this up to look at slow queries and such but not errors. Can you help figure out what I need to do so that I can fix my problem? thank you for your help in advance.

Cassidy Hunt

 

[BJCooperIT]

Was the second account granted its privileges directly or through a role?

[sup]Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)

 

[CassidyHunt]

I gave sysadm the privledges using:

grant dba to sysadm;

Thanks.

Cassidy

 

[Dagon]

Dba is actually a role. You could try giving direct privileges to the user e.g. drop user, drop any table etc.

For Oracle-related work, contact me through Linked-In.

 

[CassidyHunt]

I am curious though. The above error to me is acting as though there is an after trigger or something on the database that is has an error in it. I would think it would be permission denied if it were a permissions issue. Would that be the case?

 

[Dagon]

I'd say it's almost certainly an internal bug, so you'd need to pursue it with Oracle. However, you can also take the pragmatic approach of just trying to find a workaround and giving direct grants may be one possibility.

For Oracle-related work, contact me through Linked-In.