Lock the certain table from being accessed

[Shelyn]

Is there any function in the Sybase ASA that can lock the certain table from being accessed by outsider? Like set the password to certain table so that only authorized people with the password can access that table.

Or is there any very secure way to lock the whole database from being accessed by outsider?

 

[JeanNiBee]

Hi

Well what you 'could' do is just create a user that has access to ONLY the database you want to be 'secure'.

Then anyone who uses that username would be able to ONLY access that specific database.

Going a step further, you can add many diffrent users to a group and only allow that group access to the DB. Same effect but you can see who is actually doing what instead of having a single user manipulating all your data.

This is all system level user/group/role management. There is no "function" that will do this for you.



-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects