Subject | RE: [firebird-support] question regarding roles, users, db-owner, gbak |
---|---|
Author | Johan van Zyl |
Post date | 2004-09-01T13:15:12Z |
http://www.techtutorials.com/tutorials/sql/sql7_roles.shtml
-----Original Message-----
From: dirknaudts [mailto:dirk.naudts@...]
Sent: 01 September 2004 14:56
To: firebird-support@yahoogroups.com
Subject: [firebird-support] question regarding roles, users, db-owner,
gbak
Hi,
1. What's the use of Roles ? I can't seem to find any docs on this ,
and I haven't got/ordered HeLen's book yet :(.
2. I've made a Db to be installed at a customer's site, and added a
user which is granted some rights on some tables, SYSDBA (that's me)
pasword is not given to customer (question of responsability when sth
goes wrong). How can I allow my customer to be able to use GBAK to
shedule backup/restore of this DB, without giving him SYSDBA
password ? can I somehow 'grant' backup/restore rights to the User I
created for him ?
Best regards,
Dirk Naudts.
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.745 / Virus Database: 497 - Release Date: 2004/08/27
[Non-text portions of this message have been removed]
-----Original Message-----
From: dirknaudts [mailto:dirk.naudts@...]
Sent: 01 September 2004 14:56
To: firebird-support@yahoogroups.com
Subject: [firebird-support] question regarding roles, users, db-owner,
gbak
Hi,
1. What's the use of Roles ? I can't seem to find any docs on this ,
and I haven't got/ordered HeLen's book yet :(.
2. I've made a Db to be installed at a customer's site, and added a
user which is granted some rights on some tables, SYSDBA (that's me)
pasword is not given to customer (question of responsability when sth
goes wrong). How can I allow my customer to be able to use GBAK to
shedule backup/restore of this DB, without giving him SYSDBA
password ? can I somehow 'grant' backup/restore rights to the User I
created for him ?
Best regards,
Dirk Naudts.
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.745 / Virus Database: 497 - Release Date: 2004/08/27
[Non-text portions of this message have been removed]