Other than grant/revoke access, can we give passwords for database objects? (I am not asking about 'setting password to database')

And do we get a clue on what database you happen to be asking about?

oracle..

I'm no database expert but have you tried looking through the documentation? http://www.oracle.com

As I recall, and I haven't worked with Oracle on a serious basis since ver 9

You can assign ownership of the objects to specific users and/or groups (sames as in most db management system).

So you can have tables "belonging" to different users in the same database structure, which is what I suspect your question relates to.

I want to prevent others from truncate/delete/drop database objects, rather than setting passwords to 'database'. (so that others can just view the database, but should not be able to perform all those things I mentioned).
Setting ownership to specific users : 'grand/revoke' access
right?

So just the basics of granting permissions to users then.

So we can grant/revoke permissions to tables, but can't set passwords, right?

The username needs a password to access the table(s) or objects.

Is it 'database password' ?

http://download.oracle.com/docs/cd/B...b14231/dba.htm

http://download.oracle.com/docs/cd/B...r_accounts.htm

Thanks for info...

removed

It's logic right? Logic is at the programming level, not the database. I know, Oracle might differ. Oracle might be too confusing for me.