#Create user without login code#

Another reason not to use the name of an actual human user is the unlikelihood that a person has the exact set of permissions you want to grant the stored procedure.

We do not want to embed into our code a strong dependency on an unpredictable entity. People get sick, they quit, they get fired. Using the name of an actual human database user would be a poor idea for several reasons. ItвЂ™s important to note that вЂusernameвЂќ cannot be a role or group or built-in account or anything like that. Our interest right now is the last option, EXECUTE AS вЂusernameвЂ™. OWNER may be applied if the developer creating the procedure needs the procedure to run as the owner, most likely вЂњdboвЂќ. SELF specifies execution at the level of the individual who created the stored procedure. The first, EXECUTE AS CALLER, is the default and specifies that the stored procedure code executes at the same level of privilege as whoever invoked the stored procedure. EXECUTE AS can be used in other ways as well, including server-level code, but here we are considering the most common application, batch and stored procedure code executing at the database level. EXECUTE ASвЂ¦ДЄs you already know, the EXECUTE AS statement can be used to change the execution permission context for TSQL batch code, stored procedures, and functions (except in-line user-defined functions.

Sounds much more intellectual than вЂњthingsвЂќ.) This different way of thinking about users, as things with permissions, can be used in a very important way in the management of SQL security. (Note how database folks love to use the word вЂњentitiesвЂќ. However, users can also be thought of as entities that have permissions to perform specific tasks on SQL Server. Clearly, people need to login before they can use SQL Server.

No good at all, if you think of users just as people. Anna P., a student in Learning TreeвЂ™s course 8420, Querying Data with Transact SQL, asks вЂњWhat good is an SQL Server user with no login?вЂќ.

#Create user without login code#