Re: User permissions problem/question

m.bohse_at_quest-consultants.com
Date: 10/12/05 

Date: 12 Oct 2005 06:49:42 -0700

Can't help you with your first issue, but on the second one there are
two things to do.

First if you don't want to give them any access remove the guest
account. But keep in mind that this also would disable the possibility
to use any system stored procedures like sp_help, sp_who etc.
So if your users need to execute certain stored procedures try
Second: evaluate the permissions for the public role in those
databases, you might want to limit these further.

M

Relevant Pages

  • SQL user permissions problem
    ... I have run into an unusual error for one specific user who's ... permissions have been granted via the public role. ... and permissions to all relevant stored procedures have been set. ...
    (microsoft.public.sqlserver)
  • User/Role Permission Problem
    ... original | Remove | Report Abuse ... permissions have been granted via the public role. ... and permissions to all relevant stored procedures have been set. ...
    (microsoft.public.sqlserver.security)
  • Re: System Tables and Public Role
    ... databases is removed public from ALL the system tables. ... > I've been researching and researching but can't seem to find an answer to ... > Everything I read indicates that you should not grant permissions to the ... Am I to assume that the public role requires these ...
    (microsoft.public.sqlserver.security)
  • public role
    ... I've noticed, whilst reviewing rights granted to the public role, that it ... has permissions ... to query system objects within certain databases. ...
    (microsoft.public.sqlserver.security)
  • Re: permissions for new user to use stored procedure
    ... table - even to the public role. ... underlying tables, though.) ... Wouldn't the user have permissions on the table because they are in the ... If I create stored procedures to select from, ...
    (microsoft.public.sqlserver.security)