Re: Granting access to SYSTEM_MAKE_BACKUP() function
Duncan Groenewald <[email protected]> Sat, 23 Jun 2007 23:53:39 +1200
| Newsgroups | gmane.comp.db.mckoi |
|---|---|
| Message-ID | <[email protected]> |
--Apple-Mail-3-281472893 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed 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] --Apple-Mail-3-281472893 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1 <html><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; = -webkit-line-break: after-white-space; "> <div>I just tried this but get the following error:</div><div><br = class=3D"webkit-block-placeholder"></div><div><div>Backup = Database</div><div>"Exception executing query"</div><div>"User not = permitted to call: SYSTEM_MAKE_BACKUP"</div><br = class=3D"webkit-block-placeholder"></div><div>is there any way I can = check whether permissions have been created ?</div><br><div><div>On = 23/06/2007, at 4:16 AM, Tobias Downer wrote:</div><br = class=3D"Apple-interchange-newline"><blockquote type=3D"cite"><p = style=3D"margin: 0.0px 0.0px 0.0px 0.0px"><font face=3D"Helvetica" = size=3D"3" style=3D"font: 12.0px Helvetica"><span = class=3D"Apple-converted-space">=A0</span>grant all on = SYS_INFO.SYSTEM_MAKE_BACKUP to [username]</font></p> = </blockquote></div><br></body></html>= --Apple-Mail-3-281472893--