Re: Granting access to SYSTEM_MAKE_BACKUP() function

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]