I have a secured database and the user in question has Full Permissions
but when a make table query is run, 3033 You do not have necessary
permissions .... error is displayed. Does this user need Admin rights?

I'm a security newbee and am somewhat lost...

Jim

Rover wrote:

> I have a secured database

How do you know? (I'm not trying to be funny; it's a serious question.)


> and the user in question has Full Permissions

Permissions only make sense in regard to a combination of 4 things:
workgroup file, user or group, database, and database object. For
example, "user A in workgroup file B has full permissions to object C
in database D". A generic term like "full permissions", is really not
very meaningful in the context of Access security.


> but when a make table query is run, 3033 You do not have necessary
> permissions .... error is displayed.

Show us the sql of the query.


> Does this user need Admin rights?

Who knows? The first thing is to find out the cause of your error, no?

HTH,
TC

TC wrote:
> Rover wrote:
>
>>I have a secured database
>
> How do you know? (I'm not trying to be funny; it's a serious question.)

I did the "Steps to secure a database" from Microsoft. and made all my
shortcuts include the .mdw
>
>>and the user in question has Full Permissions
>
> Permissions only make sense in regard to a combination of 4 things:
> workgroup file, user or group, database, and database object. For
> example, "user A in workgroup file B has full permissions to object C
> in database D". A generic term like "full permissions", is really not
> very meaningful in the context of Access security.

I have assigned group permissions. When I look at the temp_table noted
below, the group has no permissions assigned. I (as administrator (I
thought)) tried to assign permissions and it says I don't have rights.

Something is set up wrong but I don't know where to go from here.

>
>>but when a make table query is run, 3033 You do not have necessary
>>permissions .... error is displayed.
>

The problem is there are some temporary tables that get deleted and
recreated. The user doestn't have permissions for those tables. That
same user can create tables though... I thought it might have something
to do with being able to create new tables. Not so.


> Show us the sql of the query.
>
>>Does this user need Admin rights?
>
> Who knows? The first thing is to find out the cause of your error, no?
>
> HTH,
> TC

"Rover" <(E-Mail Removed)> wrote in message
news:P_WdnYLAVueO5xHfRVn-(E-Mail Removed)...
>
> The problem is there are some temporary tables that get deleted and
> recreated. The user doestn't have permissions for those tables.

Why don't you just delete the contents of the table, and then run an append
query, instead of deleting the table and recreating it?


--
Joan Wild
Microsoft Access MVP

I can do that but it still begs the question of why I can't do it "my"
way...

Joan Wild wrote:
> "Rover" <(E-Mail Removed)> wrote in message
> news:P_WdnYLAVueO5xHfRVn-(E-Mail Removed)...
>
>>The problem is there are some temporary tables that get deleted and
>>recreated. The user doestn't have permissions for those tables.
>
>
> Why don't you just delete the contents of the table, and then run an append
> query, instead of deleting the table and recreating it?
>
>

"Rover" <(E-Mail Removed)> wrote in message
newsrWdnXWJYIMaOhHfRVn-(E-Mail Removed)...
>I can do that but it still begs the question of why I can't do it "my"
>way...


OK, provide the specifics. You say you assign permissions to groups. I
assume that your group has permission to delete the table? Does the group
have permission on the make-table query? What permission(s) does your group
have on <New Tables and Queries>?

Is the make table query set to RWOP?

--
Joan Wild
Microsoft Access MVP

<New Tables and Queries> don't have rights. I (as administrator (I
thought)) tried to assign permissions and it says I don't have rights.
So this is part of my problem. I assigned me an Admins group and gave
that group Admin rights but I must have set something up wrong because I
can't assign the above rights.

Joan Wild wrote:

> "Rover" <(E-Mail Removed)> wrote in message
> newsrWdnXWJYIMaOhHfRVn-(E-Mail Removed)...
>
>>I can do that but it still begs the question of why I can't do it "my"
>>way...
>
>
>
> OK, provide the specifics. You say you assign permissions to groups. I
> assume that your group has permission to delete the table? Does the group
> have permission on the make-table query? What permission(s) does your group
> have on <New Tables and Queries>?
>
> Is the make table query set to RWOP?
>

"Rover" <(E-Mail Removed)> wrote in message
news:z-GdnW2n8Mb_TxHfRVn-(E-Mail Removed)...
> <New Tables and Queries> don't have rights. I (as administrator (I
> thought)) tried to assign permissions and it says I don't have rights. So
> this is part of my problem.

Maybe not. That setting is the permissions that the Group has on any new
tables/queries that are created. It has nothing to do with whether they can
create new ones. The fact that you are logging in as a member of the Admins
Group, and can't assign permissions, suggests that you are not using the
correct workgroup file.

What permission does your Group have on the make table query? What
permission does it have on the table they are deleting?

> I assigned me an Admins group and gave that group Admin rights but I must
> have set something up wrong because I can't assign the above rights.

Check to see who the owner of the database is.


--
Joan Wild
Microsoft Access MVP