I have a multiuser database secured by the system.mdw file. In the database I have a make table query that various members of a user group can run. I have added the following sql statment to the make table query to allow all user to create the table. WITH OWNERACCESS OPTION;
My problem is, it still will not grant access to the resulting table to run the query, only to the user/owner of the make table query?