Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tmdavis1
Starting Member
6 Posts |
 Posted - 2007-12-15 : 00:11:35
|
| I have created a "read only" login on the SQL 2005 database server with rights to the public role with grant connection rights. When I use the "read only" username in Crystal Reports, the database does not show in the dropdown box. When I give "read only" sysadmin rights, all databases appear. I do not want "read only" to have sysadmin rights, is there another way around this that would truly give "read only" read-only rights?TMDavis |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-15 : 01:22:15
|
| Put the user in db_datareader role. |
 |
|
|
tmdavis1
Starting Member
6 Posts |
Posted - 2007-12-15 : 09:39:24
|
| The "read only" login has the following properties- General SQL Server Authentication Default database - Master-Server Roles Public-User Mapping Users Mapped to this login:(all databases checked) Role membership: db_accessadmin, db_datareader, public-Securables Blank-Status Permission to connect to database Engine: Grant Login: EnabledI am still not able to connect to the database using Crystal Reports unless I give the readonly user sysadmin rights.All help is appreciated.TMDavis |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-15 : 22:59:38
|
| Sounds like CR issue, checked with vendor? |
|
|
|
|
|
|
SQL 2005 connection to Crystal Reports