Re: How to grant read/write permission to a user using query analyzer
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/28/04
- Next message: MS User: "Error Handling"
- Previous message: Steve Kass: "Re: Possible Bug with SQl Server 2000"
- In reply to: harry: "How to grant read/write permission to a user using query analyzer"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 28 Sep 2004 16:06:06 -0600
Do you want to add the user to the db_datareader and db_datawriter
database roles? To do that, you can execute sp_addrolemember in Query
Analyzer, e.g.
EXEC sp_addrolemember 'db_datareader', 'SomeUser'
You can find more information in books online under sp_addrolemember.
-Sue
On Tue, 28 Sep 2004 14:44:30 -0700, "harry" <hcokoli@yahoo.com> wrote:
>All,
>
>I will like to know how to grant a user both read/write
>permission using query analyzer and not through enterprise
>manager.
- Next message: MS User: "Error Handling"
- Previous message: Steve Kass: "Re: Possible Bug with SQl Server 2000"
- In reply to: harry: "How to grant read/write permission to a user using query analyzer"
- Messages sorted by: [ date ] [ thread ]
