Dissertation Writers: What roles are available to a user by default?
How do you solve that problem?
What roles are available to a user by default? How is this a security concern?
What is a schema?
Change to SQL Server authentication. Create a login
Create a user
Create a schema
Allow the new user to write to and read from tables but not to create or delete them.
Create two instances of SSMS and connect to the database using different logins
What happens when you attempt to create a new table in each instance?