SQL user permissions problem



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

  • Re: change user1 access changes user2 access
    ... Using the public role is your problem. ... All users, whether it be User1, ... permission you are granting All users the permissions. ... > name, a password, I select a database to login to, then go ...
    (microsoft.public.sqlserver.security)
  • 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: SMS View Tables access through ODBC - Help!
    ... > view tables is required for a feed to a third party asset management tool. ... Is public role necessary to access view tables? ... with a standard user account to make sure that nothing bad happened. ... enable the select permissions to the objects you want them to view. ...
    (microsoft.public.sms.admin)
  • Re: change user1 access changes user2 access
    ... > Using the public role is your problem. ... >permission you are granting All users the permissions. ... I click on New Login. ... >> name, a password, I select a database to login to, then ...
    (microsoft.public.sqlserver.security)
  • Re: Public Role in SQL Server 2000 SP3
    ... The default permissions of the public role allow SELECT from sysobjects and ... other meta-data objects. ... A security best practice is to create your own roles and grant object ... permissions to those roles as needed. ...
    (microsoft.public.sqlserver.server)