[thelist] M$ SQL Server problems
Joel Lieberman
joel_lieberman at yahoo.com
Tue Jan 15 10:25:35 CST 2002
Norman -
You need to be careful about selecting "all"
privileges from the various lists because whilst you
can give a user the ability to create a table, you can
at the same time deny his privileges to read anything
from it!
I suggest that you create the user account at the
instance level, then at the database user level, give
permissions for db_ddladmin, db_datareader and
db_datawriter. This will enable the user to create
tables, procedures, etc., and read and write to them
whilst not having the higher privileges of DBO.
Cheers -
Joel Lieberman
--- Norman Beresford <n.beresford at anansi.co.uk> wrote:
> Hi all
>
> Hoping someone on the list can help me with a
> problem I've got with a SQL
> Server machine atm.
>
> The problem I've got is that an assigned user can
> create tables, but then
> has no permissions on those tables. The user is a
> member of all the
> pre-defined database roles, including db_owner.
> I've tried setting the
> permissions on the tables whilst logged in as
> administrator on the machine,
> but those permission changes aren't "sticking" once
> applied.
>
> Has anyone got any ideas?
>
> Norman
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
More information about the thelist
mailing list