Question: Using SQL database, I have created users and roles in tables. -- Roles table CREATE TABLE roles ( role_id INTEGER PRIMARY KEY, role varchar(20) NOT
Using SQL database, I have created users and roles in tables.
-- Roles table CREATE TABLE roles ( role_id INTEGER PRIMARY KEY, role varchar(20) NOT NULL UNIQUE );
-- User roles CREATE TABLE user_roles ( user_id INTEGER NOT NULL, role_id INTEGER NOT NULL, Constraint PKUR primary key (user_id, role_id), Constraint fk_ur1 Foreign Key (user_id) references sdev_users(user_id) on delete cascade, Constraint fk_ur2 Foreign Key (role_id) references roles(role_id) on delete cascade );
How can I create a statement to assign all users a unique ID before allowing them to access system components or cardholder data in the database?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
