Posted by teedilo@gmail.com on 01/21/06 20:12

Razvan -- Thank you so much for your thourough and informative reply.
I ran the "EXEC sp_helpuser" command for the user account in question,
and it appears that it already has db_datareader and db_datawriter
roles assigned -- those were in fact the only two roles returned by
this command. Were those the only two roles you had assigned when you
tested this?

I'm afraid that our DBA probably won't assign roles other than those
two for this user account. They don't want to give us the ability to
create foreign key constraints, or anything structural -- we can only
manipulate the data. And we're basically OK with that, but we'd still
like to create or at least view diagrams. :-( Any other ideas?
Thanks.

[Back to original message]