title: sql server alter permission
body: <p>Experts</p>
  
  <p>I am trying to set up permission for our IT team. All our IT staffs are member of I.T group. With  the database in question  the IT staffs  groups are member of db_reader, db_reader and can execute all SP/Fun. one particular user I want to give the permission to modify the objects. </p>
  
  <pre><code>CREATE USER [S\Al] FOR LOGIN [S\Al] WITH DEFAULT_SCHEMA=[dbo]
  </code></pre>
  
  <p>added him to db_ddlAmin role</p>
  
  <pre><code>EXEC sp_addrolemember N'db_ddladmin', N'S\Al'
  </code></pre>
  
  <p>all the objects in our db belongs to DBO schema..so i have give alter permission on dbo schema to the user</p>
  
  <pre><code>GRANT ALTER ON SCHEMA::[dbo] TO [S\Al]
  </code></pre>
  
  <p>But when this user tries to modify an sp or drop a table he gets </p>
  
  <p>Cannot alter the procedure 'XX', because it does not exist or you do not have permission.
  Cannot drop table 'XX', because it does not exist or you do not have permission. </p>
  
  <p>This user can create a new table, but if he tries to drop the newly  created table he get the permission error..</p>
  
  <p>This user is member of 4 other group where the group  is a member of either db_owner or db_ddladmin role, </p>
  
  <p>What am I doing wrong, how can i resolve this..</p>
  
  <p>Thanks</p>
  
  <p>VT</p>