Re: Read Only SQL Login and Crystal Reports

From: BP Margolin (bpmargo@attglobal.net)
Date: 09/14/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Fri, 13 Sep 2002 22:04:59 -0400

Donal,

Let me admit that I haven't used Crystal Reports in a long time, but I find
it hard to believe that Crystal Reports requires a login to be a member of
the sysadmin role ... in fact, if I remember a project that I worked on
where Crystal Reports was used (albeit not by me), I'm positive that the
login was **not** a member of the sysadmin role.

Have you tried creating a login, adding the login to the db_datareader
database role, and making sure that the public role does not have a set of
DENYs in it that would override the db_datareader permissions?

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Donal Devine" <ddevine@careworks.ie> wrote in message
news:eCnUVqyWCHA.1688@tkmsftngp10...
> I'm trying to setup a login to a SQL Server 2000 database, that will be
> read-only. However Crystal Reports Designer 6 will only polulate the table
> list using a login that is a member of the System Administrators role.
> This obviously gives the login too much rights, I just want to give the
> login SELECT rights on the database.
> Has anyone come across this issue?
>
> Cheers,
> D.
>
>

Relevant Pages

  • Re: Removing Users from Database
    ... If the user is a member of any ... >group-level permissions in the database, ... >double-check the server login and verify that the login ...
    (microsoft.public.sqlserver.security)
  • Re: Multiple Websites and Single Sign in
    ... a single sign-on solution which will be out in ... If you cannot have them all access the common database, ... should automicallly become the member of site2.com and site3.com. ... Anybody Please tell me how can i make a Login System(with 1000% ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: asp.net 2.0 roles not working when deploying to web server
    ... When I login in as a member of the user role, ... database problems but did not find anything applicable to my problem. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Read Only SQL Login and Crystal Reports
    ... My best guess is that somewhere the user is a member of a role that has DENY ... > Crystal Reports to interrogate the data in one of our databases, ... > them a login with such privileges. ... > The login is a member of public and db_datareader database roles in the ...
    (microsoft.public.sqlserver.security)
  • Re: Read Only SQL Login and Crystal Reports
    ... The table list only displays a list of 3 system tables when using a login ... Crystal Reports to interrogate the data in one of our databases, ... The login is a member of public and db_datareader database roles in the ...
    (microsoft.public.sqlserver.security)