[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Granting access to SYSTEM_MAKE_BACKUP() function
Is there any way I can 'hack' this without doing too much damage ? I
don't want users to have any special privileges, just the ability to
run a backup. Would it be possible to modify the code to allow
normal users to run this procedures is they have USAGE permission on
the function ? I realise you probably don't want to modify your
version of the code but could you point me to where I might modify my
own version ?
Thanks
On 30/06/2007, at 10:25 AM, Tobias Downer wrote:
> I apologize. I just checked the code and the user must belong to
> the "secure access" group to be able to call the backup procedure,
> so you need to add the user to this group if you wish for them to
> use the backup function. The simplest way to do this is by using
> the following command;
>
> insert into SYS_INFO.sUSRUserPriv ( UserName, PrivGroupName )
> values ( '[username]', 'secure access' );
>
> Toby.
>
> Duncan Groenewald wrote:
>> I don't get grantee @PUBLIC. How would I manage to get this ?
>> On 27/06/2007, at 1:48 PM, Tobias Downer wrote:
>>> Hi,
>>>
>>> The following query may help you,
>>>
>>> SELECT * FROM SYS_INFO.sUSRGrant;
>>>
>>> Look for "SYS_INFO.SYSTEM_MAKE_BACKUP" under the param column,
>>> the grantee should be "@PUBLIC". You may need to restart the
>>> database after grants are altered.
>>>
>>> Toby.
>>>
>>> Duncan Groenewald wrote:
>>>
>>>> I just tried this but get the following error:
>>>> Backup Database
>>>> "Exception executing query"
>>>> "User not permitted to call: SYSTEM_MAKE_BACKUP"
>>>> is there any way I can check whether permissions have been
>>>> created ?
>>>> On 23/06/2007, at 4:16 AM, Tobias Downer wrote:
>>>>
>>>>> grant all on SYS_INFO.SYSTEM_MAKE_BACKUP to [username]
>>>>>
>
>
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list http://www.mckoi.com/database/
> To unsubscribe, send a message to mckoidb-unsubscribe@mckoi.com
>