Loading

Users in SQL Server

Zehan Jurangpathy

Hi,

Im learning to create users in sql server. I have created a user for a database in sql server and assigned Privileges to the user as well.

I created the user as follows,

create user testUser without login;

Now i want to test this user. Can anyone tell me how to test this please??

Thanks,
Zehan

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Zehan Jurangpathy15y ago
Hi Prabhu,

Thanks for replying for my post.

When i try to run that it says,

Incorrect syntax near 'without

Can you please tell me why this happens??

Thanks
Prabhu Raja15y ago
Hi Zehan,

Try this, Give Your Username in Single Quotes in the following Query.

EXECUTE AS USER = 'testUser' WITHOUT REVERT

---------------------------------------------------------------------------------
If this helps you, then mark as "Correct Answer"
Thank You.