User/Role Permission Problem

maxrawson_at_yahoo.com
Date: 09/08/05 

Date: 8 Sep 2005 07:38:28 -0700

 maxraw...@yahoo.com Aug 25, 10:55 am show options

Newsgroups: microsoft.public.sqlserver
From: maxraw...@yahoo.com - Find messages by this author
Date: 25 Aug 2005 10:55:23 -0700
Local: Thurs, Aug 25 2005 10:55 am
Subject: SQL user permissions problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

Greetings,

I have run into an unusual error for one specific user who's
permissions have been granted via the public role.

Background: All data accessed via the asp.net application have been
set to stored procedures. 4 users have been assigned to the public role

and permissions to all relevant stored procedures have been set. All
users except one have no problem accessing data via the stored
procedures available.

Problem: One user gets an error that they don't have appropriate
permissions set to access the underlying table or view that is called
via the stored procedure.

I have double checked all SQLCommands and or SQLDataAdapters as well as

the public permissions list and I can't find anything. Besides, if it
were a problem in the application, every user would get this error.

Any feedback in regards to why this one user is encountering this error

would be greatly appreciated.

Thanks in advance for you help!

-MadMax

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)
  • Re: Help understanding Stored proc Level Secuirty?
    ... Jasper Smith (SQL Server MVP) ... I set permissions to my Stored Procedures, ... Access to stored procs fail ...
    (microsoft.public.sqlserver.security)
  • Re: Securing Stored Procedures from being seen
    ... PERMISSIONS works for the current user, whoever he may be, and however his rights were granted. ... username, but in SQL Server, there are too many users to map an individuals ... granting the group execute permissions. ... see the names of any stored procedures to which he has no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie on permissions: ADO.NET, C++.NET, SQL SERVER 2005 EXPRESS, Visual Studio 2005
    ... Permissions are per logins and users. ... permissions can be granted through stored procedures, ... an extent a trivial question since I can do programming in VS as ... "Administrator" (it's annoying to switch users using Windows XP Pro, ...
    (comp.databases.ms-sqlserver)
  • Re: Newbie: Restrict user account access to stored procedures
    ... You can deny users permissions to directly access tables and views by adding ... SQL Server does not, to the best of my knowledge, support any database role, ... stored procedures. ...
    (microsoft.public.sqlserver.security)