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

See also questions close to this topic

• What do we mean by SQL NOW() and created_at in SQL

  I have been told to test someone's code and when I pass a json, it throws the following error

  Error: No Rows found select * from otp_log where verified_at is NULL and (NOW()-created_at)<? and email_otp = ? and mobile_otp = ? 300,5581

  Error: No rows found

  I get this error when i send a put request from postman

  {
  
      "signup_request_id": "36", 
      "email_otp": "5881"
  }
  

  Now I checked that we have otp_log table in our sql and it contains email_otp and mobile_otp field already populated with data.

  The route i am using is signup/verify which as the name suggests is used to verify a user by otp.

  So can someone help me with explaining what does this exactly do. like why am I getting the error (in general)? and what does this mean (NOW()-created_at?
• Xampp not starting mysql after power failure

  Whenever my laptop goes off due to power failure, if mysql server was on before shutdown it wont start again. The only solution I had so far was to reinstall.
• IOError in python for meanwhile slide a query result

  I've got an issue with this part of python script. When I run it, it throws this error:

  IOError: [Errno 0] Error
  

  in a RANDOM ELEMENT of dbCur (result of query).

  Here is my code:

  dbCur.execute("SELECT parent_name FROM crowd.cwd_membership WHERE child_name = \'"+source+"\'")
  for group in dbCur:
      code = 999
  
      # Check sul nome visualizzato
      if ('-' in group):
          print "Aggiungo il gruppo: ", group[0], " all' utente di destinazione..."
          code = giveGroup(jira,target,group[0])
      if (code != 400 or code != 404):
          # Se andata a buon fine 
          print " ...Gruppo aggiunto con successo \n"
      if (code == 400 or code == 404):
          # Se utente o gruppo non trovati, manda in review manuale
          requireReview = True
      if (code==999):
          # Se il nome non è corretto O non esiste, non fa partire la giveGroup
          print "...Nome gruppo non valido, "
          autogrant_crowd_clog.logger.info("Errore nel nome del gruppo: "+group[0]+ " l'inserimento è stato saltato.")
  
• how to revoke update grant on one table in one schema(crm) and user(cus)

  i have lots of table in one schema with given grant(select,update,insert,delete) And now i want to remove the update grant on the attendence table how can i do schema(crm) user(cus) table(attendence) DB (dev)
• JavaScript Privilege Limitation

  I am using a partner javascript on my website. We are adding it by importing by tag.

  I wish to limit the access capabilities of the use of this javascript. How can I manage it's access to different site location and data?

  Thanks, Js
• Join two tables with information in multiple rows/multiple columns

  I'm using Postgres 9.5 and I have a table that is used to document and set user privileges on database tables (a function is called to set the privileges according to this table's entries). This table has the following columns:

  • table_name
  • schema_name
  • user_name
  • can_select
  • can_insert (and some more can_... columns for other privileges)

  Entries are only present for those table-user-combinations where a user should have at least SELECT privileges.

  For QA purposes I would like to write a function that compares this table to information_schema.table_privileges and that outputs the cases where there are discrepancies between what the user privileges should be and what they really are. This is what I have got so far:

  select 
     i.grantee, 
     p.user_name as priv_user, 
     i.table_name, 
     p.table_name as priv_table, 
     i.table_schema, 
     p.table_schema as priv_schema, 
     i.privilege_type, 
     p.can_select, p.can_insert, p.can_update, p.can_delete, p.can_truncate 
  from information_schema.table_privileges i
  full outer join priv.dashboard_table_access p
  on 
  i.grantee = p.user_name and 
  i.table_name = p.table_name and 
  i.table_schema = p.table_schema
  where (i.grantee  in ('user1', 'user2') 
  or p.user_name in ('user1', 'user2'))
  and (i.privilege_type is null or p.can_select is null)
  

  This lists the entries in each table that have no corresponding entries in the other table. However, I still lack a way of detecting that the privileges themselves are not set as desired (e.g. INSERT has been granted, even though it shouldn't be as can_insert is set to false). As I am still pretty new to SQL I don't know how to match information_schema.table_privileges's one privilege per row-setup with my own one privilege per column-table. I would simply like another record to appear in my query's output to draw attention to the fact that something is amiss in that particular case.

  Thanks for your help.
• Discuss the trigger for database table changes

  hy, This trigger will give me whole table record with all changes butt i want to get the last changed row share the code.

  Create Or Replace Trigger TRG_check IN
  Before insert or update
  on temp_checkin
  FOR each ROW
  BEGIN
  INSERT INTO temp_checkin_history
  select * from temp_checkin
  where temp_checkin.id = temp_checkin.id;
  END;
  

  thanks
• How Do I Grant User Privileges in PHPMYADMIN on linux mint

  After installing apache and phpmyadmin on linux, I was able to login using username as phpmyadmin and the password I entered when installing phpmyadmin but this user doesn't have any privilege granted to it, and I cant login as root, not password works for root, I tried all password but it didn't open.

  Please how do I grant access to this user