Re: Local system permissions
From: Kresimir Radosevic (kresimir.radosevic@zg.tel.hr)
Date: 11/30/02
- Next message: Kresimir Radosevic: "Re: Securing a web DB"
- Previous message: Shrenik Shah: "db_owner Role (SQL Server 7.0 v/s SQL Server 2000)"
- In reply to: Kim: "Local system permissions"
- Next in thread: SQL Server Development Team [MS]: "Re: Local system permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Kresimir Radosevic" <kresimir.radosevic@zg.tel.hr> Date: Sat, 30 Nov 2002 11:07:45 +0100
Check out sp_addsrvrolemember in books online
-- Kresimir Radosevic, SQL MVP I support the Professional Association for SQL Server and its user community of dedicated professionals. www.sqlpass.org "Kim" <John@Doe.com> wrote in message news:3de74b6b$1@news.carlbro.dk... > Hi > > I have been restricting permissions on our databases, which resulted in > that > I removed the builtin administrator group and created a new group for > DBA's > only. > It works fine...but when our backup program - a third party product - > which > runs under the local system account tries to make a backup of the > databases > it get an access denied. > > How can I reapply (sa) permissions to the local system account? > > thanks > > Kim > >
- Next message: Kresimir Radosevic: "Re: Securing a web DB"
- Previous message: Shrenik Shah: "db_owner Role (SQL Server 7.0 v/s SQL Server 2000)"
- In reply to: Kim: "Local system permissions"
- Next in thread: SQL Server Development Team [MS]: "Re: Local system permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|