Sql permissions

Results 1 to 2 of 2

Thread: Sql permissions

  1. #1
    Join Date
    Dec 1969

    Default Sql permissions

    I want to assign permissions to a user so that the user should be able to create a view, but should not be able to delete colums in a table created by other users or sa. <BR>can somebdy tell me what permissions shall i give??<BR><BR><BR>Thanx in advance

  2. #2
    Join Date
    Dec 1969

    Default You should create the view, not the..

    .. user.<BR><BR>And, just give the user SELECT permissions to the view, NOT the table.

Posting Permissions

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