3033 You do not have necessary permissions ....

[Rover]

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

 

[TC]

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

 

[Rover]

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

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.

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.

 

[Joan Wild]

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]

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

 

[Joan Wild]

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]

<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]

<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.