💻 Part 6: From Code to Click – Security, Permissions & Building Kai’s Dashboard

July 1, 2025

After learning stored procedures and date functions, Kai was ready for the next challenge: making the database safe  and building something real people could click and use.

🔐 Permissions: Who Gets to Do What?

We started with a simple but powerful idea: not everyone should be able to change everything.

I told Kai, “Imagine giving teachers the keys to mark attendance, but not delete students by accident.”

We created roles in SQL Server:

CREATE ROLE TeacherRole;
GRANT EXECUTE ON MarkAttendance TO TeacherRole;

Then added a user and assigned the role:

CREATE LOGIN Teacher1 WITH PASSWORD = 'SecurePass123!';
CREATE USER Teacher1 FOR LOGIN Teacher1;
EXEC sp_addrolemember 'TeacherRole', 'Teacher1';

“So Teacher1 can mark attendance, but nothing else?” Kai asked. Exactly. Principle of least privilege in action. 🔒

🧩 Kai’s First Dashboard UI

Then the big one: Kai brought me a sketch a simple web page with two boxes:

  • Who is enrolled?
  • Who showed up this week?

We started building it using ASP.NET (yes, with real HTML and C#), connecting it to the stored procedures he had already written:

// ASP.NET Backend Sample
SqlCommand cmd = new SqlCommand("GetWeeklyAttendance", conn);
cmd.CommandType = CommandType.StoredProcedure;

And then showed the results in a basic table:

<table>
  <tr><th>Student ID</th><th>Course</th><th>Days Present</th></tr>
  <% foreach (var row in attendanceData) { %>
    <tr><td><%= row.StudentID %></td><td><%= row.CourseName %></td><td><%= row.DaysPresent %></td></tr>
  <% } %>
</table>

“It’s like turning SQL into something people can use,” Kai said.

Exactly. And that’s where coding becomes empowering. 🧠

💡 Security Meets Design

We made sure the dashboard only worked when you logged in with the right credentials. We added:

  • 🔑 Basic login with hashed passwords
  • 🔍 Server-side checks for user roles
  • 📄 Read-only pages for students

Kai even insisted on a “forgot password” link — because “people always forget stuff.” 😅

✨ More Than Code: Seeing the Bigger Picture

Watching Kai map out UI screens, worry about what buttons should do, and protect the database  all while making it easier for teachers blew me away.

He wasn’t just using the tools he was thinking like a system designer. With empathy. With structure. With pride.

And that’s what this journey is really about. ❤️

👀 Coming in Part 7: Logging Absences & Building Reports

Next time, we’ll expand our system by logging absences, building summary reports, and maybe even integrating with a calendar API so students can see their schedule. 🗓️

Kai’s asking questions like: “Can we colour-code the dashboard for frequent absences?” and “Can students log in to see their record?”

Yes, and yes. Let’s build it. Together.

🫶 Keep Showing Up

If you're a neurodivergent learner, a parent, a carer — keep showing up. Progress may not always look linear, but growth is happening.

Kai’s story is living proof: with patience, passion, and the right support, amazing things happen.

See you in Part 7. Until then:

  • 💬 Ask the next question
  • 🧠 Build something useful
  • 💙 Believe in your pace

Because different doesn’t mean broken. Different often means brilliant.

Comments

Post a Comment

Popular posts from this blog

Free Monthly Budget Spreadsheet (UK-Friendly)

Want to take control of your finances and live more frugally? I've created a simple, easy-to-use monthly budget spreadsheet — perfect for UK households. Track your income, bills, spending, savings, and more in one place. 📊 What’s Included: Income and bills tracker Subscriptions and everyday expenses Savings and debts planner Savings goals section — plan and visualise your future funds £1 to £365 Savings Challenge — stay motivated as you save! 💡 What is the £1 to £365 Savings Challenge? This challenge helps you gradually save £665 in a year. You simply save an amount between £1 and £365 — one of each — and tick them off as you go. You can save the biggest amounts first, smallest first, or mix it up depending on your budget that week. It’s a flexible and fun way to build savings! 📌 Sample Data & Formulas Each sheet includes sample data to show how to use it. Please delete or replace only the numbers — not the formulas. Any field with calculation...
Read more
Image
👨‍💻 Helping Kai Build His First Front-End App It’s been a few weeks since my last post with Kai. We’ve been heads-down coding together, and instead of just talking about database security, we started building a working front end for his application. This has been a big step for Kai — going from SQL tables and stored procedures to actually seeing his app come alive in the browser. We used C# with ASP.NET Web Forms (ASPX) to create login and home pages, and then expanded into pages for courses, students, lectures, grades, and even a small library system.     🔑 Step 1: Building the Login Page Before you can get into the app, you need a secure login. We reused our earlier hashed + salted password system but wrapped it with an ASPX login form. <asp:TextBox ID="txtUsername" runat="server" Placeholder="Username"></asp:TextBox> <asp:TextBox ID="txtPassword" runat="server" TextMode="Password" Placeholder=...
Read more

Financial Literacy and ADHD – Money, Mistakes, and Learning the Hard Way

Let’s talk money. Not the flashy kind with yachts and investment portfolios. I mean the real stuff—bills, debt, impulse buys, budgeting apps, and that sinking feeling when your card gets declined at Tesco. I grew up without much. Council estate life doesn’t come with lessons in financial planning. You learn fast—or you don’t eat. But ADHD made learning about money even harder. It’s not just about being “bad with money.” ADHD affects how we make decisions, process consequences, and handle stress. Here’s what ADHD and money looks like for me: I once gave away my phone to someone who needed it… and forgot to cancel the bill. It cost me thousands . I’ve bought gadgets on a whim, convinced they’d change my life, only for them to gather dust. I’ve missed payments, not because I didn’t have the money—but because I forgot the due date. I’ve signed up to trials and subscriptions I forgot to cancel. I’ve had months where I lived like a millionaire, followed by months where I ...
Read more