Looking at the Database.java code could I modify the method below to
check if the user has SELECT permission ?
/**
* Returns true if the user is allowed to execute the given stored
procedure.
*/
public boolean canUserExecuteStoredProcedure(DatabaseQueryContext
context,
User user, String procedure_name) throws
DatabaseException {
// Currently you can only execute a procedure if you are a
member of the
// secure access priv group.
return userHasSecureAccess(context, user);
}
/**
* Returns true if the user is allowed to execute the given stored
procedure.
*/
public boolean canUserExecuteStoredProcedure(DatabaseQueryContext
context,
User user, String procedure_name) throws
DatabaseException {
if (userHasSchemaGrant(context, user,
table.getSchema(),
Privileges.PROCEDURE_EXECUTE_PRIVS)) {
return true;
}
// Currently you can only execute a procedure if you are a
member of the
// secure access priv group.
return userHasSecureAccess(context, user);
}
Post by Tobias DownerI 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.
Post by Tobias DownerHi,
The following query may help you,
SELECT * FROM SYS_INFO.sUSRGrant;
Look for "SYS_INFO.SYSTEM_MAKE_BACKUP" under the param column,
database after grants are altered.
Toby.
Post by Duncan GroenewaldBackup Database
"Exception executing query"
"User not permitted to call: SYSTEM_MAKE_BACKUP"
is there any way I can check whether permissions have been
created ?
Post by Tobias Downergrant all on SYS_INFO.SYSTEM_MAKE_BACKUP to [username]
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/