Re: Granting access to SYSTEM_MAKE_BACKUP() function

[Duncan Groenewald <duncangroenewald@xxxxxxxxxx>]

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
>