Subject | Privileges Question |
---|---|
Author | Arno Garrels |
Post date | 2003-01-09T16:53:07Z |
Hi,
I'm using FireBird 1.0, I've created a new user "FDMMASTER" and granted him
privileges like the way below for all tables in my project:
GRANT SELECT, UPDATE, DELETE, INSERT, REFERENCES ON GLOB TO FDMMASTER WITH
GRANT OPTION;
Now, when user FDMMASTER tries to execute a Alter Table SQL, he gets the
following ERROR:
EIB_ISCError: ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
STORE RDB$RELATION_FIELDS failed
no permission for control access to TABLE GLOB
How can I grant a user the right to Alter Tables??
My SQL.Text:
'Alter Table GLOB ADD BOOL_23 CHAR (1) character set ISO8859_1 DEFAULT ''F''
collate ISO8859_1'
Thanks in advance
Arno Garrels
I'm using FireBird 1.0, I've created a new user "FDMMASTER" and granted him
privileges like the way below for all tables in my project:
GRANT SELECT, UPDATE, DELETE, INSERT, REFERENCES ON GLOB TO FDMMASTER WITH
GRANT OPTION;
Now, when user FDMMASTER tries to execute a Alter Table SQL, he gets the
following ERROR:
EIB_ISCError: ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
STORE RDB$RELATION_FIELDS failed
no permission for control access to TABLE GLOB
How can I grant a user the right to Alter Tables??
My SQL.Text:
'Alter Table GLOB ADD BOOL_23 CHAR (1) character set ISO8859_1 DEFAULT ''F''
collate ISO8859_1'
Thanks in advance
Arno Garrels