Thanks for the quick response.  My next question is how to rebuild the indexes.  Is there a system stored proc?  I apologize for my ignorance.  I'm new at this.

Thanks for...

Thanks for the kind words Tim, I'm sure one day you'll be helping me out with a problem.

The beauty of these forums, is that there is always someone willing to...

Hopefully this works for you.  Just ignore the temp tables as they were used instead of creating new tables in my db.  It seemed to work O.K. for me

/****************************************************************************************************************/

DECLARE @ORGID  INT

DECLARE...

Whew!

Thanks for all the help guys.  After running the sp_change_users_login stored proc than closing and re-opening EM everything seems to be working just fine.

Thanks again for all the help

Ignore my last statement, I just had to wait a minute so the security schema could propogate.

Once again, I greatly appreciate everyone who help me get this matter resolved.

One more...

Thanks for the info Julian, your schema is a heck a lot simpler than the way I was trying to do it.  I followed your suggestions and the everything is...

Thanks for helping out a DBA Rookie Derrick.  That script worked out GREAT!!!

I really do appreciate all of the help.

So far, this is what I've done.

Created to new user roles: Grant_StoredProc_Right & Grant_Table_Rights

These are the two stored procedures that I used to...

Thanks for all the help.  I think I got it. 

The only question that I have is about the db_ddladmin role.  Why do you suggest I add this to all...

Thanks for all the help.  I think I got it. 

The only question that I have is about the db_ddladmin role.  Why do you suggest I add this to all...

I gave the user permissions on the under the databse properties.  I can finally open up a stored proc and its not grayed out.  But I can't change it.  The...

(1) If the user opens up a type "User" stored proc, everything is grayed out.  If the user trys to open a type "User" table, I see the error "SELECT...

Also, if I assign the user the System Administrators role, the user can access everything without a problem.

Thanks for the quick response.

Just so I could start testing, I created another user in Active Directory (sqluser).  The only group in AD the new user is apart of is...

Jonathan,

Thanks works great

Shane