[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Granting access to SYSTEM_MAKE_BACKUP() function

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]
>>
>