I'm not an rpm wiz, but look on your Mandrake CD's for locate, also it may be included with some other package that you may not have choosen to install. If you do find it then something like rpm -Uvh packagename.rpm will install it.
Now for a complete listing of what rpm does see JimH ;D
As for the permissions. Once you create a user, most things should already be setup to allow that user to have control over installed applications. However if they user wanted to install an application then it would have to be in that users home directory. For installing applications anywhere else, that's root's job. If you wanted to edit system wide files, that's root's job as well. It's all about security.
If you wanted to let user X play with /var/www/html then that dir would need to be owned by that user, as well as the files within. Or you could add that user to the group that owns the files. Then you would need the permissions to look something like this: rw-rw---. It would have to be that way for the directory as well as the files. Another way would be to all other to access the files. In which case nothing needs to be done about adding groups etc. Only need to modify permissions to allow other to access the files. That would like like this: rw-rw-rw-. This later method though is pretty much like saying everyone, and their gandmother need to come play with my files.