Results 1 to 2 of 2

Thread: sp_column_privileges

  1. #1
    Join Date
    Dec 1969

    Default sp_column_privileges

    I used the stored procedure sp_column_privileges to get all privileges for a given table. I&#039;m not familiar with using stored procedures so I now face the question of how to query the output of a stored procedure. Can I nest the stored procedure in a select statement. I want to find out permissions for a particular user.<BR><BR>Example: <BR><BR>Select * from (sp_column_privileges tablename) where GRANTEE=&#039;userlogin&#039; <BR><BR>Any help would be appreciated. <BR><BR>Thanks, <BR><BR>Mike

  2. #2
    Join Date
    Dec 1969

    Default RE: sp_column_privileges

    Hi Mike,<BR><BR>One way of doing that would be to create a temp table thru your stored procedure, execute the stored procedure thru ur code and then query the temp table.<BR><BR>hope this helps,<BR>Mansi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts