faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

2 of 6 people (33%) answered Yes
Recently 2 of 6 people (33%) answered Yes

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
----------------------------------------------------------------------