Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » Transfer Logins from Oracle to Sql Server
Add to briefcase

Transfer Logins from Oracle to Sql Server Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
viswanath09
Posted Monday, May 17, 2010 12:39 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 5:03 AM
Points: 82, Visits: 123
Hi all,

I need to do Transfer All Logins from Oracle to Sql Server.

Please do the needful.
Post #922722
rlondon
Posted Tuesday, May 18, 2010 8:39 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, May 03, 2013 12:41 PM
Points: 417, Visits: 1,122
What exactly are you trying to do? Oracle does not have any Logins, only Users. Are you trying to move the database from Oracle to SQL Server? If so you will most likely have to create logins for each Oracle user. To find the Oracle user's you can query the Oracle database by selecting username from the sys.dba_users table.
Post #923636
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.