Home Forums SQL Server 7,2000 T-SQL creating new users and granting permissions RE: creating new users and granting permissions

  • January 29, 2008 at 8:36 am

    #772901

    Create a role, add the user to the role.

    Grant permissions to the role with GRANT SELECT on MyTable to MyRole. Use appropriate permissions for your role.