Assigning Privileges with OEM

From: <rspeaker_at_my-deja.com>
Date: Thu, 30 Mar 2000 14:56:52 GMT
Message-ID: <8bvpvb$u4i$1@nnrp1.deja.com>

Hi,

I am using OEM. I have a generic userid called OEM created that has DBA rights to the database. Using OEM, I can create USER2 easily enough, but I also need to grant USER2 'select' access to 1 table in USER1's schema. Is there a way to do this as the OEM user, or for security reasons is it just simply not possible? Do I absolutely have to be connected as USER1 in order to grant any type of object privs to USER2?

Thanks,
Roy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 30 2000 - 08:56:52 CST