SQL reference: 08_rls_users

Production API: https://asi-database-node-api.arybit.co.ke

Source: Database/08_rls_users.sql

Engine: MySQL legacy. Status: disabled; qualification pending.

Migration ID: 08_rls_users. SHA-256 (LF): 647bbcb8319a6082ec036862974ef498c0d60c36fe8530d467c25ed641f76ab6.

Pending isolated MySQL/MariaDB compatibility, dependency and tenant-isolation validation.

Source overview

========================================================= Arybit Auth - Schema Module (MySQL Version) MODULE: 08_rls_users VERSION: 2.1.0 • December 28, 2025 Production-Ready • MySQL / MariaDB Compatible

Security & access control helper layer Implements secure lookup functions and signup/verification flow

Declared objects

• check_user_exists_safe
• check_user_permission
• consume_verification_code
• create_user_signup
• create_verification_code
• current_user_id
• get_user_by_email_safe
• get_user_by_id_safe
• get_user_roles_by_id_safe
• has_permission
• reset_user_password
• revoke_user_sessions
• verify_user_account
• verify_verification_code

This is a static source reference, not a runtime qualification. Object extraction does not interpret SQL semantics. Review the source and manifest before any schema change.

Connection guide · Migration qualification · SQL catalog