|Subject||Re: [IBO] Inserting records / access privileges|
>> Or 'A' for all.I think you are practically correct. But according to the
> Are you sure? I thought that a GRANT ALL ON MYTABLE TO MYUSER
> creates 5 records in the RDB$USER_PRIVILEGES table, each of them
> specifying the specific, granted operation (S, U, I, D, R).
documentation at least 'A' for all is an option. Also according to
the documentation the full words would appear to be valid as well
(up to 6 characters anyway).
So to cover possible "fixes" later, or direct metadata updates by
some external app, I would write my code to read a string and test
the first character and I would check for 'A'.