Dear All Experts,

Can database set a password ? if yes, how to set it?


Thanks

Jane

Please clarify your question.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

if i create one database called 'TEST' then I don't want other people can access this database. so how am I going to block the user trying to access it? means that when the users click on 'TEST' database, it will not be open and see all the tables or views inside.



Thanks

there is no password by database. There are passwords by users. You can give a user access/rights to a database. Thus indirectly you have a database password. But if userx has rights to databaseone and databasetwo they use the same password given the two databases are on the same database server instance.

You could get around this by setting up a different instance for every database, just a thought.