permissions question

Results 1 to 2 of 2

Thread: permissions question

  1. #1
    Join Date
    Dec 1969

    Default permissions question

    i have a db permissions question. I&#039;m trying create a new column in a table and i am sure the SQL syntax is right because it works in the Enerprise manager query. When i do it using an ASP page i get this error:<BR>Error Type:<BR>Microsoft OLE DB Provider for SQL Server (0x80040E14)<BR>User does not have permission to perform this operation on table &#039;table1&#039;.<BR><BR>i assume it is because the user does not have the permission to use the ALTER TABLE on the data base. The user does have the permissions to read and update. I have set and tested those. Is there another setting i need to set?

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Make that user the owner also

    basically to do all you want guive that user dbo in give that user admin permissions<BR><BR><BR>

Posting Permissions

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