select user_login, script_name, scripttype_name
from gr_user, gr_script,gr_scripttype
where script_owner=user_id and user_login != 'jsmith' and script_type = scripttype_id
order by user_login, script_name;