Is it possible to logon to Space Manager GUI with non-DBA user account?
RESOLUTION:
To allow non-DBA users to use Space Manager for a target database, grant them the Quest_SPC_APP_PRIV role.
Grant Privileges from Space Manager
To grant privileges from Space Manager, the installation DBA runs the following procedure in the SQL Editor (in the procedure, 'USER NAME' is the user name of the user being granted privileges):
Begin
quest_spc_user_manager.grant_user ('USER NAME');
End;
The procedure should be run for non-DBA users that will run Space Manager. The procedure grants the QUEST_SPC_APP_PRIV role and additional privileges to non-DBAs. It grants only the QUEST_SPC_APP_PRIV role to non-installation DBAs.
Note: Privileges must be granted after each upgrade as well as after the initial installation.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center