Results 1 to 2 of 2

Thread: permissions script

  1. 04-11-2003, 03:07 PM #1
    trentonm99
    trentonm99 is offline Registered User
    Join Date
    Apr 2003
    Location
    Illinois
    Posts
    2

    Question permissions script

    We are currently setting up a new piece of software with a SQL server 2000 database. I have created the database and have added the user "DOMAIN USER" to the users tab. This is so that any domain user can access it. I need to have a script that allows all these users to select, insert, update, delete, exec, dri for all tables contained. There ae approx. 14000 tables. I have no clue how to write this. Any help that anyone could provide would be appreciated.
    Reply With Quote Reply With Quote
  2. 04-11-2003, 07:14 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    run this in query analyzer and grab the script generated, then run the script.

    select 'grant all on ' + name + ' to ''domain user'''
    from sysobjects
    where objectproperty(id,ismsshipped)=0
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules