Re: DBA Studio : privileges
From: Brandon <nospam_at_myemail.com>
Date: Tue, 18 Mar 2003 02:27:33 GMT
Message-ID: <pan.2003.03.18.02.27.28.878925_at_myemail.com>
>
> You're only allowed to grant your own objects to other users,roles,...
>
> To do that, copy the SQL Statement (Show SQL - Button) log on with
> SQL*Plus with the user who owns the object(s) and execute the statement.
>
> regards
> berni
Date: Tue, 18 Mar 2003 02:27:33 GMT
Message-ID: <pan.2003.03.18.02.27.28.878925_at_myemail.com>
On Mon, 17 Mar 2003 12:45:09 +0100, berni wrote:
>> Hello >> When i connect under DBA studio with system/manager it is impossible to give >> rights (GRANT) to the another one users (insufficient privileges). Yet, as >> System account I have the DBA privileges. Where is the mistake? >> >>
>
> You're only allowed to grant your own objects to other users,roles,...
>
> To do that, copy the SQL Statement (Show SQL - Button) log on with
> SQL*Plus with the user who owns the object(s) and execute the statement.
>
> regards
> berni
Well, if only you had 9i this would be possible...otherwise, yes, you would have to grant object privileges as the owner. Received on Tue Mar 18 2003 - 03:27:33 CET