0
I need to create a user inside the Sql Server login with access to the Database, but I don’t want to release any other resource (such as Security, server role, Sql Agent, backup, etc). This user is for system development, there is some standard user for this purpose??
2
You create the user and in Server Roles you arrow the permissions. It is also possible to map the user directly to a DB in the User Mapping menu.
Details about Server Roles:
Browser other questions tagged sql-server
You are not signed in. Login or sign up in order to post.
Yes, I know this option. But when I release, the user is showing other SSMS options, such as: Security, server role, Sql Agent, backup. Do you have an option not to appear as a developer?? Just wanted to release the DB (tables, procedures and views).
– MMoura
@Mmoura he sees the options but can’t do anything
– gmsantos