Re: Grant Option

Naomi Walker writes: |> It appears I would have to become to creator of each table, and user the |> "WITH GRANT OPTION" to accomplish such a feat. I must be missing |> something. |> |> As informix, or a user with DBA, how may I GRANT SELECT table by |> table without becoming the explicit owner of each table? Shouldnt |> the DBA be able to do anything? Try this: GRANT SELECT ON tabname TO userlist AS owner; though it may not work. The rules on permission "chaining" can be a bit complex (I don't use privs much myself). You may wind up having to be the owner, or have the owner grant some common user appropriate privs WITH GRANT OPTION. |> While we are on this subject, can someone explain dbaccess and its |> features to me? Maybe that will be a better solution. In a nutshell, dbaccess is isql with Perform, Ace, and User Menu removed. Dave Disclaimer: The opinions expressed in this message are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney