Make tables and permission

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

Hello,

I think this is a fairly obvious question: If I want a
user to be able to run a make table query, do I have to
give the user Read, Update, Insert Data and Delete Data
permissions to New Tables/Queries? Thanks in advance to
anyone who replies.
 
Why not try it and see what happens? Create a userid with limited
permission and run a make-table query. Much easier thatn asking us to try
it for you and report back the results.

I think the answer is "No". If they can create a new object, and they are
the owner, I think they will have full permission.

Rick B


Hello,

I think this is a fairly obvious question: If I want a
user to be able to run a make table query, do I have to
give the user Read, Update, Insert Data and Delete Data
permissions to New Tables/Queries? Thanks in advance to
anyone who replies.
 
Barry said:
Hello,

I think this is a fairly obvious question: If I want a
user to be able to run a make table query, do I have to
give the user Read, Update, Insert Data and Delete Data
permissions to New Tables/Queries? Thanks in advance to
anyone who replies.
Click to expand...

No you don't. Permissions on New Tables/Queries don't affect whether a user
can create these objects; rather the permissions you set are those that will
apply to new objects, regardless of who creates them. That said, the user
that creates a table, owns it, and therefore has full permission on it.

You may find your need is better met by emptying a table and then appending
records to it, rather than creating a new table. This could be accomplished
without giving the user *any* permissions to the table.
 
Back
Top