Re: Security Script
From: Sammy The Bull (NoOne_at_NoWhere.com)
Date: 08/21/03
- Next message: Sang Leen: "How user can change their password with sp_password."
- Previous message: Paul Ross: "MS03-033 Unchecked Buffer in MDAC"
- In reply to: Dan Guzman: "Re: Security Script"
- Next in thread: Dan Guzman: "Re: Security Script"
- Reply: Dan Guzman: "Re: Security Script"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 21 Aug 2003 10:46:28 -0400
Don't think that's it.
You when you restore a database, or attach it, SQL Server maintains the
logins but removes all permissions to databases and their objects. There
apparently is a script that assists in restoring access to databases, and
permissions to the objects.
"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
news:unobRQ#ZDHA.2032@TK2MSFTNGP10.phx.gbl...
> Are your referring to sp_change_users_login? You can find documentation
> for this procedure in the Books Online
> <tsqlref.chm::/ts_sp_ca-cz_8qzy.htm>.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> -----------------------
> SQL FAQ links (courtesy Neil Pike):
>
> http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> http://www.sqlserverfaq.com
> http://www.mssqlserver.com/faq
> -----------------------
>
> "Sammy The Bull" <NoOne@NoWhere.com> wrote in message
> news:eZYGmF%23ZDHA.1872@TK2MSFTNGP12.phx.gbl...
> > This has probably been asked a million times but...apparently there is
> a
> > script available on microsoft.com that will assist in re-setting up
> security
> > on SQL Server after a restore/sp_attach_db...does anyone know where I
> can
> > find it, or what to search under?
> >
> > Thanks.
> >
> >
>
>
- Next message: Sang Leen: "How user can change their password with sp_password."
- Previous message: Paul Ross: "MS03-033 Unchecked Buffer in MDAC"
- In reply to: Dan Guzman: "Re: Security Script"
- Next in thread: Dan Guzman: "Re: Security Script"
- Reply: Dan Guzman: "Re: Security Script"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
