Users in SQL Server

Question

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

Zehan Jurangpathy · Answer

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 Raja · Answer

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.