Your user NewDomain\javierrosas does not automatically have the same
permissions as Domain_nt\javier. You will have to add permissions to this
new login. Or you can run sp_change_users_login, as suggested by Ron, to
link the security account for a user in the current database with the new
login.
On other words, your new login will not automatically replace the old
login, but you can map the new login to the existing dB user ID without
losing the user's permissions.
Regards,
Lan Lewis-Bevan
SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.programming)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.programming)
Re: ODBC in MS Access ignores DSN authorization method ...login doesn't have permissions, you get an error. ... to use a trusted connection or a SQL login, ...>permissions, and instead use the PUBLIC permissions. ... >When the Windows login I am using has access to the database, ... (microsoft.public.sqlserver.odbc)
