Page 1 of 1

how to create dbtable 2 for a login user

Posted: Wed Mar 17, 2021 12:45 am
by 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

Re: how to create dbtable 2 for a login user

Posted: Wed Mar 17, 2021 7:14 am
by Pablo
Only one database can be used per website.

Re: how to create dbtable 2 for a login user

Posted: Wed Mar 17, 2021 8:06 am
by 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.

Re: how to create dbtable 2 for a login user

Posted: Wed Mar 17, 2021 8:20 am
by Pablo
There is only one table for the login tools.
What exactly are you trying to do?

Re: how to create dbtable 2 for a login user

Posted: Wed Mar 17, 2021 8:36 am
by 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

Re: how to create dbtable 2 for a login user

Posted: Wed Mar 17, 2021 9:58 am
by 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.

Re: how to create dbtable 2 for a login user

Posted: Wed Mar 17, 2021 10:13 am
by 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?

Re: how to create dbtable 2 for a login user

Posted: Wed Mar 17, 2021 11:30 am
by 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.

Re: how to create dbtable 2 for a login user

Posted: Wed Mar 17, 2021 11:58 am
by kfi4all
Thanks!