[Feature] Add User Role

[OmegaHawkeye]

From kirimase created by MichaelMaherKamel: vercel#33

It would be nice to add the user role as an enum {'admin', 'user'}, and it should reflect in the NextAuth Sessions and the DB

[OmegaHawkeye]

I agree this would be nice. FWIW, I found I needed to reimplement the pgDrizzleAdapter myself because by default it uses its own embedded table definitions rather than the developer's Drizzle schema. So, if you add "role" to your users table, it will not return it because it is not included in the embedded createTables . I implemented my own pgDrizzleAdapter and set adapter to that in /src/app/api/auth/[...nextauth]/route. Thanks to [Mohammad Anas]:(https://medium.com/@anasmohammed361/implement-next-auth-auth-js-with-drizzle-adapter-aws-rds-postgres-15a8d148ec99)

[OmegaHawkeye]

Thank you @pjholmes

Well, for me, I took another path, it might not be very practical, but it did the job for me till next-auth fixes it or adds a way for Drizzle like they did for Prisma as explained here -- https://authjs.dev/guides/basics/role-based-access-control

I have extended the User Schema in the auth.ts file to hold the user Role as below:

src > lib > db > schema > auth.ts

---

export const users = mysqlTable('user', {
  id: varchar('id', { length: 255 }).notNull().primaryKey(),
  name: varchar('name', { length: 255 }),
  email: varchar('email', { length: 255 }).notNull(),
  emailVerified: timestamp('emailVerified', {
    mode: 'date',
    fsp: 3,
  }).defaultNow(),
  image: varchar('image', { length: 255 }),
  role: mysqlEnum('role', ['admin', 'user']).notNull().default('user'),
})

In my protected page, which is /admin, I am fetching the server session and saving the session.user.id in a variable, then fetching this user from the DB and comparing the roles, for example

src > app > admin > page.tsx

---

import { getServerSession } from 'next-auth'
import { authOptions } from '../api/auth/[...nextauth]/route'

import { db } from '@/lib/db'
import { eq } from 'drizzle-orm'
import { users } from '@/lib/db/schema/auth'

import SignIn from '@/components/auth/SignIn'

const AdminPage = async () => {
  const session = await getServerSession(authOptions)
  if (session) {
    const userId = session.user.id
    const [u] = await db.select().from(users).where(eq(users.id, userId))
    return (
      <>
        Signed in as {session.user?.name}
        {u.role === 'admin' ? (
          <div>
            <br />
            Admin
          </div>
        ) : (
          <div>
            Not an Admin
          </div>
        )}
      </>
    )
  }
  return (
    <>
      Not signed in <br />
      <SignIn />
    </>
  )
}

export default AdminPage

========================

Cheers 🤞🏻