prevent user to build new tables and/or queries

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

Guest

hello,
i have built a database and I have secured it following all the necessary
steps.
It works fine but... the user can still create new table or queries although
if I look at the permissions settings he has no rights for new tables and new
queries.
Someone who knows what is wrong?

thanks, God bless microsoft's newsgroups!
Rocco
 
rocco said:
hello,
i have built a database and I have secured it following all the necessary
steps.
It works fine but... the user can still create new table or queries
although
if I look at the permissions settings he has no rights for new tables and
new
queries.
Someone who knows what is wrong?
Click to expand...


The permissions on 'new tables/queries' has nothing to do with *whether*
they can create these objects, but instead the permissions they will have on
any newly created objects. The exception would be those that they create
themselves (as owner, they have full permissions).

There is code in the security FAQ you can use to prevent creation of new
objects.
See http://support.microsoft.com/?id=207793
 
Another thing you want to watch, Rocco: If you don't want a specific user to
have a specific right, make sure you haven't given it to them AND make sure
you haven't put them in a group that has it. Say you put Slimer in a group
called Editors. You don't give Slimer the right to delete tables, but the
Editors group does have that right, Slimer will still get that right.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy
 
Back
Top