Granting create table to database role

From: Ryan Breakspear (r.breakspear_at_removespamfdsltd.co.uk)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 10:48:53 -0000

Hi All,

You'll have to forgive me for not knowing too much about SQL Server
security. Here is the scenario:

I have a user called FDS, which owns the database and all user tables. I
have two database roles, one FDS_User which has select/update permissions on
all tables, and one FDS_Admin. I want any users with the FDS_Admin role to
be able to modify the structure of tables (actually only three of them but
I'll settle for all if it's easier). The user 'ryan' has both roles, and
can select from any tables, but can't create/modify them. The create
statement returns "Specified owner name 'fds' either does not exist or you
do not have permission...", and the alter table statement returns "User does
not have permission to perform this operation on table 'Ryan'."

In enterprise manager -> database properties -> permissions, the FDS_Admin
role has a tick in the Create Table box.

Does anyone have any ideas how I can get the above to work? Let me know if
you need any more information.

Thanks in advance

Ryan