Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009
    Posts
    41

    Unanswered: Role informaion in MYSQL.

    How can we get the role information in MYSQL?

    Like we get in ORACLE from USER_ROLE_PRIVS table.

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    There is no support for groups of users or SQL ROLES (which are groups of privileges) in MySQL.

    It is not mentioned in the list of new features in 5.0, or in the roadmap of future development for MySQL 5.1 or 5.2.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    May 2009
    Posts
    41
    If I have installed mysql using "mysql-essential-5.1.34-win32.msi" on "Comp1" and I want to connect to Comp1-> Mysql server from Comp2.

    Then Is there any client requirement on Comp2 (like Oracle we have client) or I need to install "mysql-essential-5.1.34-win32.msi" this on Comp2 also.

    If Client is required, Where Should I get this client?

    Also If I need to access mysql server installed on windows from Unix platform(linux, Solaris, HPUX) So what are the steps to do on all these Unix platform to get connection on windows mysqlserver.


    Amit

  4. #4
    Join Date
    May 2009
    Posts
    41
    I am trying to build the my project on HPUX (HP-UX oscar B.11.11 U 9000/800 741028561 unlimited-user license) which access the Mysql library. But it is giving error as :

    Error : MySQL51/lib/hpux/libmysqld.a(client.o) - shared library must be position independent. Use +z or +Z to recompile.

    I am using this option in building:
    aCC -Wl,+s,-E,+vnocompatwarnings -z -g0 -b -Wl,-Bsymbolic.

    I also tried using the +Z, +z, also added CFLAGS=-fPIC in makefile.Still it is giving error.

    I have taken the mysql library from : mysql-5.1.34-hpux11.11-hppa2.0w.tar.gz

    Can you please suggest the solution?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •