Hi friends
As part of security on database objects ,i have created Schemas and
differents users related to schemas ,but only part of my requirement is solved , when i log in with particular user i am able to see only allocated tables which is fine ,but user is unable to do any DDL operation ,it giving message as user is not logged in as Database owner or administrator.
if i assign any db roles for this user then all the database tables are visible ,other than the specified objects which is failure .
please let me know is there any option such that the user should have full control that to only on specified particular schema objects.
Thanks