You need to grant select (search only) permissions on the new index table for public users. This lets public users search using the new index table. In addition, you grant select, insert, update, and delete permissions on the new table for staff. This lets staff, specifically Cataloging staff, create and delete records stored in the new index table.
You complete all the steps in this task using your SQL query tool. Make sure to watch for errors as you run queries.
To grant permissions on the index table for public and staff
1 | Use this command to list your user accounts: |
2 | Use this command to list your user group accounts: |
sp_helpgroup
3 | Use this command to grant select permissions for public users and groups: |
grant select on table to user(s) or group
For example, enter this command:
grant select on titlKW_word to PACGROUP
4 | Use this command to grant staff permissions: |
grant all on table to user(s) or group
For example, enter this command:
grant all on titlKW_word to STAFFGROUP
© 1998-2017 Sirsi Corporation