[Firebird-devel] [ firebird-Bugs-229231 ] revoke is case sensitive

[<no...@so...>]

Bugs item #229231, was updated on 2001-01-18 04:50
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=229231&group_id=9028

Category: Core Engine
>Group: Fixed v0.9-5
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Claudio Valderrama C. (robocop)
Summary: revoke is case sensitive

Initial Comment:
If I create a user called "admin" and then grant all privileges on a table to them, the revoke command doesn't work unless I use the "admin" name in upper case.

Here is an example:

grant all on config to "admin";
revoke all on config from "admin";

You would think this would result is admin having no privilege on config but a select on the RDB$USER_PRIVILEGE table shows the "admin" user still has full access!  You need to do:

revoke all on config from "ADMIN"

in order to remove the privileges!


----------------------------------------------------------------------

>Comment By: Claudio Valderrama C. (robocop)
Date: 2001-05-19 00:52

Message:
Logged In: YES 
user_id=62823

The engine first tries to distinguish between a role and a 
user, by brute force: finding the possible role. If we have 
a user (role not found), the name should be uppercased, 
since users are in uppercase. This was the missing code.


----------------------------------------------------------------------

Comment By: Claudio Valderrama C. (robocop)
Date: 2001-05-04 00:38

Message:
Logged In: YES 
user_id=62823

Changes in dyn.e to be tested soon.


----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=229231&group_id=9028