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 [email protected]
>



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]