granting table permissions

  • Thread starter Thread starter Taher
  • Start date Start date
T

Taher

I have a make table query, now i want to secure that table
by allowing user to only view the table, not modify or
delete it after running the query.

First i tired to create a table then i assign right to it,
but every time make table query runs it gets deleted,
hence the security gets deleted.

So if you could give me an example, i know what to do ,
but i need an example to do that.

Thanks
 
Could you set the "new table" permissions?

Didn't I just answer this in another group? How many times are you gonna
ask this same question?


I have a make table query, now i want to secure that table
by allowing user to only view the table, not modify or
delete it after running the query.

First i tired to create a table then i assign right to it,
but every time make table query runs it gets deleted,
hence the security gets deleted.

So if you could give me an example, i know what to do ,
but i need an example to do that.

Thanks
 
Granting permissions on the 'new table/query' won't work in this case, since
the user will be the owner of the resulting table.

A better option would be to create the table and remove all permissions on
it.

You could then run a delete query to empty the table, and then an append
query (both of these would need to be RWOP queries).

For viewing purposes, you'd create a RWOP query with just read data
permission on it.
 
Back
Top