On Sat, Jan 01, 2005 at 11:04:16 -0500,
Jason Dixon <jason(at)dixongroup(dot)net> wrote:
> Is it possible to GRANT permissions on multiple objects at once? I
> would like to assign limited permissions on multiple objects (tables,
> indices, sequences in the same database) without granting full
> ownership. For example, something like this:
Yes, but not the way you want. You can list multiple objects of the same
type when issuing a GRANT command. However you can't use a query in the
GRANT statement to generate the list. If you are doing this programatically
you could do a select for each type and use the results to build GRANT
statements.