Subject | Grant statement! |
---|---|
Author | Dinh Tu Nguyen |
Post date | 2006-01-10T08:37:37Z |
Hi group!
I'm using Firebird 1.5.2 and Jaybird 2.0. When I excecute a statement: grant
rolename to username (all in uppercase),it success,but the privileges of
that rolename are not granted to username( I check it in EMS IB Manager).If
I execute a statement like : grant all on tablename to username.It's OK. Is
there any problem?
And how can I get the roles that have been granted to a specific user?
I don't find any information in system tables.
Thank in advance!
[Non-text portions of this message have been removed]
I'm using Firebird 1.5.2 and Jaybird 2.0. When I excecute a statement: grant
rolename to username (all in uppercase),it success,but the privileges of
that rolename are not granted to username( I check it in EMS IB Manager).If
I execute a statement like : grant all on tablename to username.It's OK. Is
there any problem?
And how can I get the roles that have been granted to a specific user?
I don't find any information in system tables.
Thank in advance!
[Non-text portions of this message have been removed]