GRANT in SQL*Forms v2.3

Hi,

        Just a quickie (but one that's got me beat.)

        How can I write a GRANT statement in a SQL*Forms trigger to use values from the form i.e. :-

GRANT select ON table TO &user

	(this gives me a `missing or invalid username(s)' error and the line
	 appears to get converted to :- `grant select on tablename to :1')

The idea is that I'll bung it in a post-update trigger, so that whenever my list of users is updated, the trigger will GRANT the appropriate privileges. Also, will I be able to use values for the privilege and object name too ?

        e.g. GRANT &priv ON &object TO &user

Alternatively, if you know of a more elegant way to do this (maintain a table with a list of users and assign privileges whenever the table is updated) then I'd like to know that too.

                Thanks

                        David McCann Received on Tue Sep 21 1993 - 20:25:04 CEST