No problem...Hopefully it helped you 😀

Best Regards,

Inno

Hey there,

Here's a link to a similar question.

http://www.sqlservercentral.com/Forums/Topic369117-6-1.aspx#bm369938

Hopefully the link will answer all of your questions. For SELECT statments, you must definetly grant the user the db_datareader.

Best Regards,

Inno

Well...guys...I found my issue after a long day of searching....

I was trying to create a user from dbo...so that ain't going to work never ever...

But i kinda like solved my...

I figured it out....I just removed the execute as...and that was all..

Also I changed the commands, instead of Drop login- i used sp_droplogin...it works now...

It has been such a pain...

Ohh and then again it's not working. I can now create users but my programm crashes if I delte the execute as command

Done that....removed EXECUTE AS OWNER...and now it works..

Well I have approles and everything else....but the mapping is my problem...I just can't create the users. My programm works fine but, the SQL part...it's mind bobbling. And I'm a...