Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    31

    Unanswered: SP_RENAME question

    I would like to rename TBL_A to TBL_B and also transfer the user access permissions.
    Does the below command just renames the table and also transfers the permissions?
    EXEC SP_RENAME 'TBL_A', 'TBL_B'

    Is there a command to generate the user permissions on a table like 'db2look' in DB2.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    The rename does not affect permissions on the object. They will be carried over. In order to inspect the permissions on the object, you can use
    Code:
    sp_helprotect tablename

Posting Permissions

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