Now i want to create only one login table for all users including admin, staff and customers and assign their respective roles to them. can you help me with that?

Red Team answered on August 11, 2023 Popularity 1/10 Helpfulness 1/10

Comment

SELECT UserID, Role FROM Users WHERE Username = 'provided_username' AND Password = 'provided_hashed_password' AND IsActive = 1;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: chat.openai.com

Tags: assign roles sql

Link to this answer
Share Copy Link

Contributed on Aug 11 2023

Red Team

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.