SANCHIT SHARMA
Active member
- Joined
- Jul 15, 2005
- Messages
- 38
- Programming Experience
- 10+
We created a database, with a new owner "AA" and Password "BB". While we create any table ,view or any procedure it gets prefixed with dbo...
This feature makes it public in nature.. our requirement is
The table we created with owner "AA" and password "BB" should only be handled by user AA for all administrative work.
We want only our application to access the database and the user should not be able to access our database tables if he tries to access the data with a sa (system administrator) log in. Kindly help us.
How to overcome this situation , Pls. Help
Regards
This feature makes it public in nature.. our requirement is
The table we created with owner "AA" and password "BB" should only be handled by user AA for all administrative work.
We want only our application to access the database and the user should not be able to access our database tables if he tries to access the data with a sa (system administrator) log in. Kindly help us.
How to overcome this situation , Pls. Help
Regards