Removed user level security, now there's trouble

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I went through the process of removing user level security and now I find
that I can not create tables or queries. I open my db in exclusive mode and
am pretty sure that I am Admin at that point.

When I try to save a new query I get the following error, "You do not have
the necessary permissions to use the 'MSysTables' object. Have your system
administrator or the person who created this object establish the appropriate
permissions for you."

When I try to create or link a table, I get the following error, "Could not
create; no modify design permission for table or query 'tablename'."

I'm not one to panic, but I'm beginning to worry. What is the way out of
this mess I've created for myself?

much thanks in advance.
 
Try creating a new database and importing all the objects (don't import any
Msys objects).

How did you remove security? Sounds like you missed a step.
 
I was able to import all objects into a new db and it works now. I followed
the steps outlined in the secfaq and also additional details from Lynn Trapp
(see "removing user level security" post below this one).

You're right, I must have missed something along the way. I guess it's a
good thing that it's not very forgiving when it comes to security.

Thanks for your time. This forum is a great place.
JMorrell
 
Back
Top