Re: How do I let users create databases and only let them delete their own?
From: Brian Moran (briancmoran_at_hotmail.com)
Date: 04/29/03
- Next message: Steve Thompson: "Re: Auditing SQL Server"
- Previous message: johnechavez_at_earthlink.net: "tried dts copy of tables stored procedures etc and it fails exery time"
- In reply to: Michael Fong: "How do I let users create databases and only let them delete their own?"
- Next in thread: Michael Fong: "Re: How do I let users create databases and only let them delete their own?"
- Reply: Michael Fong: "Re: How do I let users create databases and only let them delete their own?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 29 Apr 2003 12:45:39 -0400
I don't see how you could do that in SQL2K. You'd have to create the DB for
the person and then make them DBO.
-- Brian "Michael Fong" <michael.fong@nospam.none.nt.gov.au> wrote in message news:#oIjJCiDDHA.1304@TK2MSFTNGP11.phx.gbl... > Hi there, > > I have a user who I have granted the "Database Creators" Server Role, but > with this they > can delete or modify any database they want. > > I want the user to create and then only be alloed to delete and modify thier > own databases ( ie only if they are the dbo ) > > Any idea on how I can do this, > > Cheers, > > Michael > >
- Next message: Steve Thompson: "Re: Auditing SQL Server"
- Previous message: johnechavez_at_earthlink.net: "tried dts copy of tables stored procedures etc and it fails exery time"
- In reply to: Michael Fong: "How do I let users create databases and only let them delete their own?"
- Next in thread: Michael Fong: "Re: How do I let users create databases and only let them delete their own?"
- Reply: Michael Fong: "Re: How do I let users create databases and only let them delete their own?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
