I have 3 projects for 3 oracle instances and 10-15 users associated with different projects is there any way i can list the users associated with all the projects .. i know one method of id -p but for that i have to su to each user
The system was handed over to me configured by external vendor and how do we associate a new user to existing project ?
Is this users under Unix or is it Oracle users? For users under unix you can for example use groups and then you can list all the users in the group.. (even a simple cut and grep of the group file will do that). You can also group the users in a netgroup (and yes you can use nis without using it for auth but as a simple database) -- then you can use all the ypcat commands to get a list of users in the netgroup...
Cheers Dyna
PS: There is a lot of different ways..
The info is in /etc/user_attr
if the user has an entry with a project attribute defined in the /etc/user_attr extended user attributes database, then the value of the project attribute is the default project. See the user_attr(4) man page.