Forum Home
Press F1
Thread ID: 88596	2008-04-01 23:11:00	SQL server permissions	Mike (15)	Press F1

Post ID	Timestamp	Content	User
655117	2008-04-01 23:11:00	Is it possible to give a SQL user permissions to add tables to a database but not have permissions to delete tables (including their own)? Or to add fields to a table, but not have permissions to delete fields (including their own)? Or is it possible to allow them to add tables, but not delete any but their own, same with fields within a table? We want all users to be able to add tables to a (specific) database, and all users to be able to add fields to any table within that database (whether they created that table or not), however we only want the admin users to be able to delete tables or fields. Is it possible? If so, how? :) Currently we can assign all or none permissions... either the user can add and delete, or they can't do both. We want them to do one and not the other. We also can't seem to specify whether they can add fields but not tables, but that may be another problem altogether... Thanks, Mike.	Mike (15)
655118	2008-04-01 23:55:00	Yes, this is possible, although you may need to edit the MySQL privelege tables directly. Just allow the users to use CREATE, but not DROP. Also allow ALTER for adding fields. If you're not using MySQL then I don't have a clue how to do this, as MySQL is what I generally use.	Erayd (23)
655119	2008-04-01 23:56:00	MS SQL Server :) But I imagine (hope) that if it can be done in mysql it should be able to be done in mssql... Mike.	Mike (15)
655120	2008-04-02 05:48:00	Take a look at the syntax for GRANT, and see what MS-SQL allows. You may be able to achieve the same thing.	Erayd (23)
655121	2008-04-02 18:49:00	Take a look at the syntax for GRANT, and see what MS-SQL allows. You may be able to achieve the same thing.OK I'll have a look. Thanks, Mike.	Mike (15)
1