network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 7 months |
| seen | Oct 10 '12 at 14:31 | |
| stats | profile views | 0 |
|
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? |
