ardatun schrieb am 24.05.2010 um 12:27:08 (-0000):
[[firebird-support] Another question on grant]

> To: firebird-support@yahoogroups.com
> User-Agent: eGroups-EW/0.82
> X-Mailer: Yahoo Groups Message Poster
> From: "ardatun" <atunccekic@...>
> List-Id: <firebird-support.yahoogroups.com>
> Date: Mon, 24 May 2010 12:27:08 -0000
> Subject: [firebird-support] Another question on grant
> Reply-To: firebird-support@yahoogroups.com
> Content-Type: multipart/alternative;
> boundary="aYXGcdtQJGw2X4vaqkric9qCMgnipQz8xo1ma5D"
>
> Hi again :)
>
> This command runs without giving any errors :
>
> grant select on FIYAT to xzxczczzxczz
>
> But I don't have any object named as xzxczczzxczz

If you GRANT TO <name>, then this is always for a user, not for any
object. Check it out running "show grant" before and after committing
your GRANT statement; it'll show:

GRANT SELECT ON FIYAT TO USER XZXCZCZZXCZZ

> This is not a problem, but why? :)

I think it is not a problem because using gsec, you might allow a user
name XZXCZCZZXCZZ to connect to your database.

Note that you do create databases, tables, views, indexes, domains,
generators, procedures, triggers, exceptions and roles, but you do not
create users.

--
Michael Ludwig