Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Granting security thru OEM (or any other tool)
So, there I am, in OEM 2.1. I'm connected to my 8.0.5 instance as SYS and I
just created a table in JUSER's schema. Now, I try and grant SELECT priv
(or any other priv) on that table, but I can't, of course, because of
Oracle's misdirected sense of security. HEY! I'M THE DBA, DAMMIT! LET ME
DO MY JOB! <grumble grumble>
I had this grandiose idea of having a single SECURITY user that would have all security to all objects with grant capability, but it's just not working. And how is security supposed to work thru OEM, when I won't be able to connect as the owner of the object to be able to do the grant???
Anyone have a DECENT way of dealing with this limitation? Does 8i at least
allow a DBA to deal with security? Or am I missing something obvious
(please tell me I am)?
Yours ventingly,
Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA -----------------------------------------------------------------------
This message has been scanned for viruses with Trend Micro's Interscan VirusWall. Received on Tue Jun 13 2000 - 10:25:32 CDT
![]() |
![]() |