May 27, 2010 at 9:04 am
Hi guys...
I have an external application that acess my database and this application needs to access just one single table, but it should have enough permission to change the structute of the table, such as, create a new attribute. My question is... How can I permit that user acess just that table with this permission??
since now, thanks,
Rafael - BR
May 27, 2010 at 3:12 pm
You can go into the properties of the user and then add the table under 'Securables' and grant them Alter permissions plus you can grant them the rest of the permissions for that table if you want(select,insert,update,ect..)
May 28, 2010 at 6:28 am
Thanks a lot for your reply...
Its works for me.
att.
Rafael - BR
March 14, 2011 at 12:52 pm
Follow-up question to Raphael's: To clarify, with this method *only* the object listed as a securable is accessible to the user, i.e., and they are denied access to all other database objects? Does this work in SQL Server 2000 as well, or is there another method in that case?
Many thanks for the question, Raphael!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply