HELLO HOUSE

HAS ANYONE GOT A VAST UNDERSTANDING ON XML PROGRAMMING? I WANT TO QUERY A DATABASE FROM AN XML DESIGNED FORM (MICROSOFT INFOPATH) USING STORED PROCEDURES. CAN ANYONE HELP?

CHEERS

the syntax to grant privileges or roles to a user:

1. sqlplus conn [username/password] @[database name] as SYSDBA

NOTE: YOU MUST BE CONNECTED AS A SYSDBA BEFORE YOU CAN GRANT ANY PRIVILEGE OR IF YOU ARE NOT A SYSDBA, YOU MUST HAVE BEEN GRANTED PRIVILEGES WITH ADMIN OPTION (THIS WILL ALLOW YOU TO GRANT OTHERS SYSTEM PRIVILEGES) OR WITH GRANT OPTION (TIHS WILL ALLOW YOU TO GRANT OTHERS OBJECT PRIVELEGES)

2. sqlplus> grant [privilege] | [privilege, privilege,, ] ON OBJECT
to user
NOTE: YOU MUST HAVE CREATED A USER BEFORE YOU GRANT A PRIVILEGE OTHERWISE YOU WILL RECEIVE AN ERROR

eg. sqlplus conn tom/tiger @buran as SYSDBA

, connected

sqlplus> grant SELECT, UPDATE, INSERT, DELETE ON HR
to ZAI
, grant succeded