IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New SQL/Server roles
I want to enable a group of developers the create tables owned by a specific user.

I ASSUME this is based on roles, ie:

create a master user "mis".
create a role "mis_devel".
Grant this role to all developers.

Somehow (here's where I get lost) give this role the
ability to create tables owned by "mis".

Or is this not possible, so I need to merely grant all
users the ability to create tables as "dbo" which
is the database owner.
New Hmm... From MS' (confusing) Web site:
"GRANT ... TO ... AS ..." ? [link|http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ga-gz_8odw.asp|http://msdn.microsof...ts_ga-gz_8odw.asp]

Idunno; HTH...


   [link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad]
(I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Resident [link|http://z.iwethey.org/forums/render/content/show?contentid=119792|zIWETHEY pilkunnussija]
New I gave up
This is a shared development environment so made them all "Database Owners" and told them to prefic dbo. in front of every table access statement.

     SQL/Server roles - (broomberg) - (2)
         Hmm... From MS' (confusing) Web site: - (CRConrad) - (1)
             I gave up - (broomberg)

Should be pasted on all overpasses.
60 ms