Re: How do I let users create databases and only let them delete their own?
From: Michael Fong (michael.fong_at_nospam.none.nt.gov.au)
Date: 04/30/03
- Next message: Kalen Delaney: "Re: How do I let users create databases and only let them delete their own?"
- Previous message: Andrew J. Kelly: "Re: tried dts copy of tables stored procedures etc and it fails exery time"
- In reply to: Brian Moran: "Re: How do I let users create databases and only let them delete their own?"
- Next in thread: Kalen Delaney: "Re: How do I let users create databases and only let them delete their own?"
- Reply: Kalen Delaney: "Re: How do I let users create databases and only let them delete their own?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 30 Apr 2003 08:49:08 +0930
Yeah, that's what I thought.
Basically I am stuck because of the design of the application I am trying to
lock down.
It stores each new record set as a new database, so without create database
the application
won't work.
Cheers,
Michael
"Brian Moran" <briancmoran@hotmail.com> wrote in message
news:#BcJ68mDDHA.2384@TK2MSFTNGP12.phx.gbl...
> 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: Kalen Delaney: "Re: How do I let users create databases and only let them delete their own?"
- Previous message: Andrew J. Kelly: "Re: tried dts copy of tables stored procedures etc and it fails exery time"
- In reply to: Brian Moran: "Re: How do I let users create databases and only let them delete their own?"
- Next in thread: Kalen Delaney: "Re: How do I let users create databases and only let them delete their own?"
- Reply: Kalen Delaney: "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
|
|
