Subject | Owners and Roles |
---|---|
Author | rodbracher |
Post date | 2007-06-26T15:07:57Z |
Hello
If I restore a database with a user 'READONLY', this user becomes the
owner.
READONLY only has rights to 'Select' on the tables of the database.
When READONLY performs a backup and restore, READONLY can no longer
Select data from tables.
I tried to create a READROLE and grant READONLY to the role, the same
thing occurs.
I assign all rights and create ROLES with SYSDBA.
As a summary of what I am trying to achieve, I want to limited rights
user to be able to backup / restore the database.
Is this possible?
Using Windows Superserver 2.0.1
Thanks
Rod
If I restore a database with a user 'READONLY', this user becomes the
owner.
READONLY only has rights to 'Select' on the tables of the database.
When READONLY performs a backup and restore, READONLY can no longer
Select data from tables.
I tried to create a READROLE and grant READONLY to the role, the same
thing occurs.
I assign all rights and create ROLES with SYSDBA.
As a summary of what I am trying to achieve, I want to limited rights
user to be able to backup / restore the database.
Is this possible?
Using Windows Superserver 2.0.1
Thanks
Rod