I have a web application. We have two users in the db. One for the
standard website user who has only read access to the db. The other is
an admin user that has full access so I can create, alter and delete
tables etc.
I'd like the web user to be able to create/drop temporary tables for
some processing that requires a temp table. It seems that to create a
temp table you have to have the same create rights as if that use
could create 'Real' tables. Same with the rights to drop temp tables.
Am I missing something or is there a way to enable a user to
create/drop temp tables but not 'real' tables.
Please reply to newsgroup. Thanks.
standard website user who has only read access to the db. The other is
an admin user that has full access so I can create, alter and delete
tables etc.
I'd like the web user to be able to create/drop temporary tables for
some processing that requires a temp table. It seems that to create a
temp table you have to have the same create rights as if that use
could create 'Real' tables. Same with the rights to drop temp tables.
Am I missing something or is there a way to enable a user to
create/drop temp tables but not 'real' tables.
Please reply to newsgroup. Thanks.