6 reputation
2
bio website
location
age
visits member for 2 years
seen Oct 10 '12 at 14:31

Oct
8
comment How to create database, and add user linked to login?
I added more actual results to the original block. All I want to do is create a login, create a database, set that the default database for that login to the new database, and create a user in that database linked to the login.
Oct
8
comment How to create database, and add user linked to login?
I added more actual results to the original block.
Oct
8
revised How to create database, and add user linked to login?
added 1097 characters in body
Oct
8
revised How to create database, and add user linked to login?
added 1097 characters in body
Oct
5
comment How to create database, and add user linked to login?
OK, I will ignore this for now and see if I can continue with what I need to do. I just wanted to totally understand the environment I am creating. THANKS for the input.
Oct
5
awarded  Editor
Oct
5
revised How to create database, and add user linked to login?
added 481 characters in body
Oct
5
comment How to create database, and add user linked to login?
I have done a little DBA work in the Oracle environment. I am new to the Windows/MS SQL environment and the permissions and user scope are a little confusing. I am trying to create my own logins and users so I understand all the privileges that are necessary without overlooking defaults. I was concerned about the CURRENT_USER being dbo in the new DB because I thought it might have an impact as I create new objects there. I am trying to create an environment for added applications that use an existing database that I do not want to modify or change (other than any required permissions)
Oct
5
comment How to create database, and add user linked to login?
Also when I do use master select CURRENT_USER I get WMC_SQLMGR as the current user. when I do use WMC_main select CURRENT_USER I get dbo as the current user.
Oct
5
comment How to create database, and add user linked to login?
THe last statement to create the user WMC_SQLMGR under the WMC_main database fails because dbo is already connected to the login WMC_SQLMGR
Oct
5
awarded  Student
Oct
5
asked How to create database, and add user linked to login?