Is there anyway to make the authentication table with 2 separate table
currently my authentication table has following fields
username,password,userlevel,higherlevel,profile
I would like to separate the above table into 2 tables as
1)authentication // mssql database “DB”
a)username → Login username
b)password → Login password
2)authentication2 // mysql database “LinkDB”
a)userlevel → User Level
b)higherlevel → Parents Level
c)profile → Profile Field
NOTE :: I can not use the view table as the above 2 table will be store in 2 different database.
As I am working to a old database of a company I have only readonly permission on “DB”