Shoot the DBA's

[gandolf989]

We are in the process of upgrading to 9i here. I am writing a package that accesses a table in another schema and I have permission to the table granted through a role.

I asked the dba's to do a direct grant to the schema owner so that I could compile my new package, and I was told that it is department policy not to do direct grants on select to anyone. and there are no exceptions to this rule.

So I sent the dba a select from dba_tab_privs showing a direct grant to the schema owner from the other user, and an excerpt from tahiti explaining why I needed it. I would have thought that being a dba he would have known about the changes in security with 9i as well as how they do grants. Apparently not. Which is funny because there are 64 direct grants in another database from one schema to another.

I could do my job if it weren't for the d mn dba's!!!!!

[pando]

that must be some mainframe db2 dba

[Mr.Hanky]

Shut the F up and get back to work you miserable whiney "know it all" DEVELOPER!!

Find something else to do instead of crudley attempting to flex your big brain.

Love,
MH

[gandolf989]

Originally posted by Mr.Hanky
Shut the F up and get back to work you miserable whiney "know it all" DEVELOPER!!

Find something else to do instead of crudley attempting to flex your big brain.

Love,
MH

You're my hero Mr. Hanky.

btw, this was an Oracle DBA.

[Mr.Hanky]

C'mon, I gots nothin but love for ya and you know it.
Besides I am just looking out for your job security and the good of the company.

[gandolf989]

Originally posted by Mr.Hanky
C'mon, I gots nothin but love for ya and you know it.
Besides I am just looking out for your job security and the good of the company.

Where I work we are all about job security. We are a non profit.
Just don't love me too much.