Sql Server 2008 -- limiting user rights?

[davej]

I can't figure out how to create a database account with restricted rights from cPanel so I am wondering how this is accomplished? Is this a "trapdoor" type of thing that is accomplished via accesses to the database? As an alternative is there perhaps a list of commands I could filter out to create the same result? Does anyone have this figured out? Thanks.

[justsomeguy]

If you're using cPanel then you probably can't create users via SQL, but if you can then you use this: http://msdn.microsoft.com/en-us/library/ms173463.aspx With MySQL users in cPanel there is an interface where you specify the permissions you want the user to have, I've never seen cPanel interact with SQL Server.