granting table permissions

[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

 

[Rick B]

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

 

[Joan Wild]

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.