Re: Database permissions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 13:00:24 +0530

Hi,
Use the below system procedure to give the windows user /group to access sql
server

sp_grantlogin 'domain\group_or_user'
GO

Go to the database which user need access.

use <dbname>
GO
sp_grantdbaccess 'domain\group_or_user','FINANCE'

--Finance is the database user

Thanks
Hari
MCDBA

"John Bell" <JohnBell@discussions.microsoft.com> wrote in message
news:BE232D83-E110-40F9-8945-B46C01DBCA0A@microsoft.com...
> Hi
>
> Check out sp_grantlogin to grant a login to the SQL Server and sp_adduser
to add a user to the database.
>
> John
>
> "Timothy V" wrote:
>
> > Hi,
> > I'm wondering what code assigns a user to a database using 'Windows
> > Integrated' authentication.
> >
> > I have an ASP.NET application that says access is denied to user Network
> > Service (IIS6.0).
> >
> > Thank you in advance,
> >
> > Tim.
> >
> >
> >

Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: Help me!
    ... When you're exploring the data in BI Development Studio, the connection is ... to the database pointed to by your data source, you'll be able to see the ... However, when you deploy to an AS server, the connection is ... Or you can set it up to impersonate a specific Windows user ...
    (microsoft.public.sqlserver.datamining)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)