how to create dbtable 2 for a login user

[kfi4all]

Hello! I have successfully designed a login system but have a problem creating a second database table that is hidden from other users.
Please, I need a solution. thanks

[Pablo]

Only one database can be used per website.

[kfi4all]

Thanks for the reply.
I am not referring to creating more than one database for a user but having a user to two or more tables in a database.

[Pablo]

There is only one table for the login tools.
What exactly are you trying to do?

[kfi4all]

I am working on a business website that creates accounts for sales staff. The website is expected to keep track of the sales of each staff in a second table. Different from the users' table; so, that the manager can access the sales report of each staff, without seeing other staff sales report.
Thanks

[Pablo]

How is this related to the login tools?
If you have custom code that keeps track of the sales, then this can be a different table.

[kfi4all]

Thanks for all your effort.
The relationship with the login tool is that having created a second table for the login account; I expect that once the user login, he or she shouldn't see the activities of other users in the database view. On the contrary, every user sees the activities of other users (this ought to be private). So, what should I do to keep a user from seeing other users' activities?

[Pablo]

You cannot use different tables for different users. There is one table for all users. There is only one login session.
If you need more advanced functionality then you will need to customize the scripts.

[kfi4all]

Thanks!