Entry

Database: Microsoft:SQL server: User: Permission: Change: How change permission of user to database?

Dec 22nd, 2003 15:35
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 23 December 2003 - 00:33 am -------------------

Database: Microsoft:SQL server: User: Permission: Change: How change 
permission of user to database?

---

Steps: Overview:

 1. -Possibly add first a user to your database in Microsoft SQL server

 2. -Start Microsoft SQL server 'Enterprise manager'

 3. -Select your database

 4. -In the left pane click '+'
    of 'Microsoft SQL Servers'

 5. -click '+' of 'SQL Server Group'

 6. -click '+' of your server
     (e.g. (local) (Windows NT))

 7. -click '+' of 'Databases'

 8. -click '+' of your database

      e.g. select the 'Northwind database'
           on my computer here

 9. -select from list 'Users'

10. -right click on the user of your choice
     (e.g. DELLI8500\ASPNET)

11. -select from list 'Properties'

12. -enable zero or more checkes in
     'Permit in Database Role'

     e.g. -enable checkbox 'db_owner'
     to give that user ownership to
     that database

----------------------------------------------------------------------