Re: Create table & deny delete table
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/30/03
- Next message: Sue Hoegemeier: "Re: Windows authentication"
- Previous message: Kalen Delaney: "Re: Create table & deny delete table"
- In reply to: hrhoe: "Create table & deny delete table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 30 Oct 2003 13:19:54 -0700
If you gave the user just create table permissions (no other
roles involved) then the table can't be created as being
owned by dbo. The user needs to be a member of db_owner or
db_ddladmin roles (or sysadmin) to create a table owned by
dbo. And then users of db_owner and db_ddladmin have the
ability to do more than just create tables but they also can
drop tables.
-Sue
On Thu, 30 Oct 2003 11:23:05 -0800, "hrhoe"
<hrhoe@hotmail.com> wrote:
>Hi,
>I'm trying to create a new login that has the following:
>- This user need to create a table.
>- The created table should have name like
><db_name>.dbo.<table_name> (not like
><db_name>.<User>.<table_name>
>- This user should not be allowed to delete a table does
>not belong to he or she.
>
>Can I create a user login like this?
>
>Thank you,
>
>- Hyung -
>
- Next message: Sue Hoegemeier: "Re: Windows authentication"
- Previous message: Kalen Delaney: "Re: Create table & deny delete table"
- In reply to: hrhoe: "Create table & deny delete table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
