Create table & deny delete table
From: hrhoe (hrhoe_at_hotmail.com)
Date: 10/30/03
- Next message: Mike Epprecht [SQL Server MVP]: "Re: Is encryption of SQL Server necessary or even recommended"
- Previous message: Andrea Montanari: "Re: can't connect to MSDE SP3 on Windows 2003"
- Next in thread: Kalen Delaney: "Re: Create table & deny delete table"
- Reply: Kalen Delaney: "Re: Create table & deny delete table"
- Reply: Sue Hoegemeier: "Re: Create table & deny delete table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 30 Oct 2003 11:23:05 -0800
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: Mike Epprecht [SQL Server MVP]: "Re: Is encryption of SQL Server necessary or even recommended"
- Previous message: Andrea Montanari: "Re: can't connect to MSDE SP3 on Windows 2003"
- Next in thread: Kalen Delaney: "Re: Create table & deny delete table"
- Reply: Kalen Delaney: "Re: Create table & deny delete table"
- Reply: Sue Hoegemeier: "Re: Create table & deny delete table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]