September 2, 2010 at 8:24 am
i have a database that i use for security reporting and one of the people that uses the reports wants to create tables in the database to populate with his own data. he already has read access to the security data in the database
is there a way to allow him to create tables but not to be able to modify the existing data in the tables that are already present? only create tables and populate them
September 2, 2010 at 8:46 am
This may not be the ideal way but my gut reaction would be to go into permissions for the database and grant the user create table permission on the database. Once the user created the table you would then have to grant them permission on that table to update data on that specific table. Since you only want them to update the table they created I believe you would have to asign that on a table by table basis.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
September 2, 2010 at 9:20 am
thx
decided to just create a separate database for that person to go wild in
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply