sql server dts: Greetings,

Well I don't think I have an Orphaned User problem but similar.

I DTS copied a database to a new SQL Server. It seems that all my user ids
have lost public role rights.

Why I think this?

sp_change_users_login 'report' returns no entries. So I assume that means
that there are no orphans.

Create Table is grayed out for all my public role user ids.
They can also not update table design for tables they are the owner of.

They do show up with public role checked off for the database I am working
with, but it sure doesn't seem like it.

Any suggestions?

Figured I would post my solution so someone else doesn't send a night up
scratching their head.

I forgot the application I was using grants additional rights to public role.
When I was lookign threw the install sql script I found.
'grant create table to public'

Of course I was happy to find the answer....

--
Message posted via http://www.sqlmonster.com