|
Home > Archive > MS SQL Server security > September 2005 > User/Role Permission Problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
User/Role Permission Problem
|
|
| maxrawson@yahoo.com 2005-09-08, 11:23 am |
| 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
| |
| Tom Moreau 2005-09-08, 8:23 pm |
| Likely, the stored proc is using dynamic SQL, in which case, you need to
grant them access to the underlying tables. Please post the proc's code and
we can confirm.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
<maxrawson@yahoo.com> wrote in message
news:1126190308.682934.303780@f14g2000cwb.googlegroups.com...
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
|
|
|
|
|