[thelist] M$ SQL Server problems

[Joel Lieberman]

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/