Results 1 to 2 of 2

Thread: Access Issues

  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149

    Unanswered: Access Issues

    Hi All-

    We have a third party app that my company recently bought. It runs on SQL Server 2000. But the way the app is set up is that "Public" need write permissions. If I change this, the app will break. In this situation, can I create a read-only user on this database?

    I don't think it is possible. Just want to make sure ....

    - CB

  2. #2
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    you can create a user and add this user to the database role called "db_denydatawriter". This deny right is applied over the "public" write right.
    Johan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •