Mapping Logins to DBO User 
Author Message
 Mapping Logins to DBO User
Is there a way to map logins for NT User or Group to dbo user in databases?
I am getting an error "User 'dbo' already exisits" when I try to change user
for login in the SQL Server Login Properties.

Thanks for help!

Michael



Fri, 04 Apr 2003 03:00:00 GMT
 Mapping Logins to DBO User

You can use:
1/sp_addalias <login>,dbo
but it is obsolete and it need not be supported in future
2/create a normal db user and give him db_dbowner role. But then he should always
use dbo. prefix when creating objects.

Hi
Michal

Is there a way to map logins for NT User or Group to dbo user in databases?
I am getting an error "User 'dbo' already exisits" when I try to change user
for login in the SQL Server Login Properties.

Thanks for help!

Michael

.



Sat, 05 Apr 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. To deteremine NT logins + Sql Logins with sa + dbo + prviliges

2. Mapping logins to users

3. Users automatically mapped to logins.....

4. Transferring logins/users/logins

5. pgsql/src/backend/utils/mb/Unicode (UCS_to_8859.pl iso8859_2_to_utf8.map iso8859_3_to_utf8.map iso8859_4_to_utf8.map iso8859_5_to_utf8.map utf8_to_iso8859_2.map utf8_to_iso8859_3.map utf8_to_iso8859_4.map utf8_to_iso8859_5.map)

6. Orphaned logins (dbo & sa)

7. undefined nt logins getting sa or dbo privileges??

8. SA no longer mapped to DBO

9. User dbo has the wrong User Login Name

10. dbo has no login mapped!

11. drop the mapped logins

12. restore all user defined user role and logins after restore


 
Powered by phpBB® Forum Software