Subject | Re: Privileges - How To?? |
---|---|
Author | Svein Erling Tysvær |
Post date | 2005-06-02T14:24:07Z |
In general, you're not allowed to do anything within a database unless
you're granted rights. Hence, it is a matter of allowing users,
denying users is the "default".
I've got a couple of guesses that may explain what you observe:
1) You haven't changed the SYSDBA password from masterkey to something
else and IBEasy+ tries this.
2) The user you're trying to deny is the creator of the database or
some of the tables you're trying to deny him access to (or a user that
restored the database).
3) The user you're trying to deny has root prviledges on Unix/Linux.
4) You're trying to deny SYSDBA access!
Tell us if any of these are true,
Set
you're granted rights. Hence, it is a matter of allowing users,
denying users is the "default".
I've got a couple of guesses that may explain what you observe:
1) You haven't changed the SYSDBA password from masterkey to something
else and IBEasy+ tries this.
2) The user you're trying to deny is the creator of the database or
some of the tables you're trying to deny him access to (or a user that
restored the database).
3) The user you're trying to deny has root prviledges on Unix/Linux.
4) You're trying to deny SYSDBA access!
Tell us if any of these are true,
Set
--- In firebird-support@yahoogroups.com, "brcr11" wrote:
> I'm a dumby!! I have a very simple DB with 5-6 tables and 3 users. I
> set the privileges for user = user1 to no privileges on all tables
> yet in my app I can attach with that user ID and password, access
> and modify data in the tables. I've tried setting the privileges
> using IBEasy+ and with isql command line. The isc4.gdb file in the
> Firebird/bin directory gets modified, IBEasy+ seems to work OK but
> my app just merrily accesses and modifies the DB no matter what.
> With the same user and password IBEasy+ won't even let me look at
> the tables. I assume my app is looking at the isc4.gdb DB since
> password verification works OK and it's the only isc4 file on the
> machine. HELP????