table security

T

Taher

I did get awnser to the questions, but if i try to use the
grant command, access sql does not accept it because the
ANSI92 is not included, hence if you could tell me which
commands to use to grant new table permisions , and do i
have to grant rights at end or beginning of maek table
query.
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?


message
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


..
 
R

Rick B

Huh?

Go to Tools/Security/User and Group Permission.

Change the "Object Type" to "table" then select "New Tables/Queries" and set
the permissions you desire for the users or grroups desired.

This will apply any time a new table is created.

NOTE: I believe the maketable query will cause the person making the table
to be the owner. They WILL have owner's permission to the table.

Rick B.


I did get awnser to the questions, but if i try to use the
grant command, access sql does not accept it because the
ANSI92 is not included, hence if you could tell me which
commands to use to grant new table permisions , and do i
have to grant rights at end or beginning of maek table
query.
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?


message
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


..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top