How to grant privileges for specific table for user in mysql?

See also questions close to this topic

• Problem with data sent from android inside php file can't handle it

  I have a user name variable data sent from Android and then dealing with this data when I dealt with this data problem appeared briefly problem when I type if ($j = = $find _id) I do not get the required data inside Android but if I replace the variable $find _id by 2, for example no problem occurs and I get the data what is the problem with this variable? Note Use an external server on a site table 1 table 2

  // get_req.php
  <?php
  // include Marei DB Class 
  include 'DB.php';
  $data = file_get_contents("php://input");
  $obj = json_decode($data);
  $db = DB::getInstance();
  header('Content-Type: application/json');
  $len= $db->getCount();
  $movies = array();
  $users = $db->table("requests")->Qget();
  $username= "";
  
  
  if(!isset($obj->{'user_name'})) {
  //print json_encode(['status' => 0, 'message' => 'Username is Non !']);
  }else{
  $username = $obj->{'user_name'};
    //print json_encode(['status' => 1, 'message' => 'Username is Don !']);
  }
  
  
  
  $rows = $db->table('users')->get();
  
  $filter_value1 = [];
  $filter_value2 = [];
  
  $count=0; 
  $find_id=0;
  
  foreach($rows as $row){
    $filter_value1[]=$row->user_email;
    $filter_value2[]=$row->id;
   // if($filter_value1[$i] == "gmal")
    if($filter_value1[$count]==(string)$username){
      $find_id=$filter_value2[$count];
    }
      // echo "$row->name <br>";
    $count++;
  }
  //echo($find_id);
  $i = 0; 
  foreach($users as $user){
      //echo $user->post_content;
      $j =  $user->user_id;
      if($j==$find_id){
      $movies[$i]['id'] = $user->id;
      $movies[$i]['user_id'] = $user->user_id;
      $movies[$i]['name'] = $user->name;
      $movies[$i]['title'] = $user->title;
      $movies[$i]['status'] = $user->status;
      $i++;
  }
  
  }
  
  $index = 0;
  if(isset($_GET['index'])){
      $index = $_GET['index'];
  }
  
  $end = $index + 3;
  
  if($index>(count($movies) -1)){
       echo json_encode(array());
       exit;
  }
  
  if($end > (count($movies) -1)){
  //  $end = count($movies) - 1;
      $end = count($movies);
  }
  
  $data = array();
  
  
  for($i=$index;$i<$end;$i++){
      $movies[$i]['type'] = 'movie';
      $data[] = $movies[$i];
  }
  
  echo(json_encode($data));
  
• Why do I have to use subquery to select the ID with the max Salary?

  I have an interview question to select the maximum salary with the ID.

  The correct answer should look like:

  SELECT WORKER_REF_ID,  BONUS_AMOUNT FROM Practice.Bonus
  WHERE BONUS_AMOUNT = (SELECT MAX(BONUS_AMOUNT) FROM Practice.Bonus);
  

  Why shouldn't we use the subquery here instead of

  SELECT WORKER_REF_ID,  BONUS_AMOUNT FROM Practice.Bonus
  WHERE BONUS_AMOUNT = MAX(BONUS_AMOUNT);
  

  ?

  Sorry, I am a new beginner with a simple question.
• Is there a way to download the HTML5 geolocation database?

  I appreciate the accuracy of the Javascript based HTML5 geolocation API and would like to download the database used in the API for my own purposes. Any database format is fine but preferably a file that works well with MySQL.

  Is there a way to acquire this database?
• PostgreSQL - Comment itérer sur une fonction qui retourne les privilèges d'un rôle donné sur chaque base mais pour l'ensemble des rôles

  Admettons la fonction suivante qui retourne les privilèges sur les différentes bases pour un rôle donné ...

  CREATE OR REPLACE FUNCTION database_privs(text) RETURNS table(username text,dbname name,privileges  text[])
  AS
  $$
  SELECT $1, datname, array(select privs from unnest(ARRAY[
  ( CASE WHEN has_database_privilege($1,c.oid,'CONNECT') THEN 'CONNECT' ELSE NULL END),
  (CASE WHEN has_database_privilege($1,c.oid,'CREATE') THEN 'CREATE' ELSE NULL END),
  (CASE WHEN has_database_privilege($1,c.oid,'TEMPORARY') THEN 'TEMPORARY' ELSE NULL END),
  (CASE WHEN has_database_privilege($1,c.oid,'TEMP') THEN 'CONNECT' ELSE NULL END)])foo(privs) WHERE privs IS NOT NULL) FROM pg_database c WHERE 
  has_database_privilege($1,c.oid,'CONNECT,CREATE,TEMPORARY,TEMP') AND datname not in ('template0');
  $$ language sql;    
  

  L'appel à la fonction se fait : select * from database_privs('My_rôle');

  J'aimerais appeler cette fonction mais en itérant sur l'ensemble des rôles existants au niveau de mon cluster de bases (au sens postgres) afin de dumper l'ensemble des infos dans un fichier csv..

  Mais je bloque...

  Merci de votre aide.
• Accidentally delete root account in phpmyadmin

  I accidentally deleted the root account, somehow, in my phpMyAdmin in Windows 10 without using XAMPP. Now, I only can remove user but cannot add users in user accounts. How can I re-give privileges to root@localhost?

  https://i.stack.imgur.com/QJUfr.png
• MySQL Error: The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

  I got this error message and can't come with a solution. Everything I tried (from deleting the user, to grant and flush privileges) didn't work. I read lots of posts about it but nothing there worked.

  I got a new mac (Mojave) and I started to install everything for my project to work. I installed mysql2 (version 8.0.1) through brew and when I tried created databases or show databases, it always got me this error.
• How to grant trigger access to a table

  I'm getting an error message for a trigger I've successfully created.

  I've tried...

  GRANT SELECT ON OTHER_TABLE TO [me];
  call SYS.DBA_ASSIST.GRANT_OBJ_PERMS('dbo.MYTABLE','SELECT','dbo.OTHER_TABLE');`
  

  Here is the code for the trigger...

    CREATE OR REPLACE TRIGGER PREVENT_INVALID_ID
    BEFORE INSERT OR UPDATE ON dbo.MYTABLE
    FOR EACH ROW
    DECLARE ROW_COUNT NUMBER;
    BEGIN
    SELECT COUNT(*) INTO ROW_COUNT 
           FROM [OTHER_TABLE] WHERE OTHER_TABLE_ID = :new.MYTABLE_ID;
    IF ROW_COUNT = 0 THEN
      RAISE_APPLICATION_ERROR(-20101, 'The ID provided is invalid.');
      END IF;
    END;`
  

  The error message in user_errors says, "PL/SQL: ORA-00942: table or view does not exist"

  

  Any idea how I can get the trigger to access OTHER_TABLE?

  I understand that it is not possible to grant access/authorizations to triggers. But I'm unclear what code I need to run in order to allow the trigger to work.

  Thanks in advance, josh
• No privilege 'Select' found for inputs { database:default})(state=42000,code=40000)

  I'm working on Ubuntu and hive 2.0.1. hiveserver2 is launched correctly. On beeline and when I type use default; I have this error

      Error: Error wh`enter code here`ile compiling statement: FAILED: SemanticException MetaException(message:No privilege 'Select' found for inputs {database:default}) (state=42000,code=40000)
  

  and it's the same thing for: create, update query. i do these commands

  mysql> CREATE USER 'hduser'@'%' IDENTIFIED BY 'hduser';
  mysql> GRANT all on *.* to 'hduser'@localhost identified by 'hduser';
  mysql> flush privileges;
  

  but the problem persist. what should i configure?
• Transfer rights from user to another user

  I have 3 tasks:

  1. Create a database owner with 'sa' rights.
  2. Create three database users.
  3. Transfer the rights from the user from task 1 to one of the users from task 2.

  I know how to solve first and second tasks:

  CREATE USER admin WITH LOGIN PASSWORD 'password' SUPERUSER;
  CREATE USER user1 WITH LOGIN PASSWORD 'user1';
  CREATE USER user2 WITH LOGIN PASSWORD 'user2';
  CREATE USER user3 WITH LOGIN PASSWORD 'user3';
  

  How can I solve third task?