PC Review


Reply
Thread Tools Rate Thread

3033 You do not have necessary permissions ....

 
 
Rover
Guest
Posts: n/a
 
      17th May 2005
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

 
Reply With Quote
 
 
 
 
TC
Guest
Posts: n/a
 
      18th May 2005

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

 
Reply With Quote
 
Rover
Guest
Posts: n/a
 
      19th May 2005


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


 
Reply With Quote
 
Joan Wild
Guest
Posts: n/a
 
      19th May 2005
"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


 
Reply With Quote
 
Rover
Guest
Posts: n/a
 
      19th May 2005
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?
>
>


 
Reply With Quote
 
Joan Wild
Guest
Posts: n/a
 
      19th May 2005
"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


 
Reply With Quote
 
Rover
Guest
Posts: n/a
 
      19th May 2005
<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?
>


 
Reply With Quote
 
Joan Wild
Guest
Posts: n/a
 
      19th May 2005
"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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Do not have necessary permissions to use object (Error 3033) Assess6768 Microsoft Access Security 4 8th Oct 2009 11:26 AM
Disable workgroup permissions-Error 3033 niclive@gmail.com Microsoft Access Form Coding 3 31st May 2007 11:24 AM
Access DB - Security Error 3033 You do not have necessary permissions .... news.online.no Microsoft Access Security 1 1st May 2007 02:26 PM
3033 do not have the necessary Permissions to use 'MSysTables' =?Utf-8?B?anN3ZWRsdW5k?= Microsoft Access Security 3 9th Mar 2006 12:14 AM
(Error 3033) You do not have the necessary permissions to use ... =?Utf-8?B?RXJpbiBNb29yZQ==?= Microsoft Access 5 17th Nov 2004 05:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:37 PM.