Permissions question - SQL 2000 1

[panini]

Hi there,

I've worked out how to control a users access to tables within my database using roles. However, I want to give no access to most tables, select, insert, delete to another and complete unrestricted access to another - including design view, etc so they can add more columns - in fact i'd really like them to be able to add new tables too - is this possible without giving them admin rights across the database?

Many thanks,

 

[hmckillop]

Yes you can do this. If you use Enterprise manager go to your database, select the user you want to manage (or create one), then right click and select permissions.
This will show you all objects in database and the permissions for them. you can select options such as give them delete on one table, exec on a stored proc etc.
You get the fine level of granularity you require.


"I'm living so far beyond my income that we may almost be said to be living apart

 

[panini]

many thanks!