Re: Adding User to Standard Role

From: Narayana Vyas Kondreddi (answer_me@hotmail.com)
Date: 10/15/02 

From: "Narayana Vyas Kondreddi" <answer_me@hotmail.com>
Date: Tue, 15 Oct 2002 17:42:39 +0100

That's strange. Though the rights don't show up for a user included in a db
ficed role, he/she should be able to select from the tables in the database.

I wonder how the Crystal Reports app is connecting to the database. Also,
try sp_helprolemember and see if your user shows up in the output. 

--
HTH,
Vyas, MVP (SQL Server)
SQL Server FAQ, articles, code samples, interview questions and more @
http://vyaskn.tripod.com/
"Monica" <qwerty9988@hotmail.com> wrote in message
news:308301c27461$53708d10$35ef2ecf@TKMSFTNGXA11...
> After adding a user to a standard role (for example,
> db_datareader) the permissions that are supposed to be
> associated with that role do not show up for the user.  Is
> this just implied by being assigned the role, or am I
> doing something wrong?
>
> The reason I am asking this, I was trying to use Crystal
> Reports to access my database.  Unless I explicitly
> allow 'Select' permission for each table I want to use, I
> cannot access the tables from this software.  Even though
> the user is specified as db_datareader.
>
>

Relevant Pages

  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie: I dont understand user permissions for table access
    ... > My database is remote to my workstation. ... > tables/fields WITHOUT specifying anything in the permissions dialogs? ... >> HOW are you connecting to SQL Server? ... what rights/permissions have been granted to the PUBLIC role? ...
    (microsoft.public.sqlserver.server)
  • Re: Execute Persmission denied on object sp_OACreate
    ... SQL Server is creating a job behind the scenes. ... SA account password and gaining access to the database. ... > SQL Server doesn't check permissions on indirectly referenced objects as ... > the proxy account security context for non-sysadmin users from Enterprise ...
    (microsoft.public.sqlserver.security)
  • Re: Security question ..
    ... What I want to prevent is any access to the database accept through our ... application unless you have elevated permissions. ... Authentication, if he is smart enough to create an NT Auth ODBC connection ... passes through to the database or to use SQL Server authentication. ...
    (microsoft.public.sqlserver.server)