Assigned Permissions Not Saved in SQL Server 2000 1

[markgrizzle]

Hi,
I logged in as SA, and created a login and user. I then granted the user rights to execute some stored procedures. This was all done using the dialog boxes.

When I returned to the dialog, the execute checkboxes were unchecked. I then wrote a script to do the same thing. The script ran without errors, but again, the permissions weren't set.

Has anyone seen this behavior? Can anyone recommend steps to resolve it? I believe we're up to date on service packs, etc.

Thanks in advance.

 

[mrdenny]

This is normal, the client doesn't show the permissions. This thread thread962-1324602 has code which shows how to query this information from the database.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog