Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I would suggest using OAuth 2.0. This supports getting both identity and access to APIs -- so accomplishes the same end goal, but is much easier than OAuth 1 Hybrid.</p> <p>Take a look here: <a href="https://developers.google.com/accounts/docs/OAuth2Login" rel="nofollow">https://developers.google.com/accounts/docs/OAuth2Login</a></p> <p>The scopes you're trying to access are included in the URL (see "Forming the URL"). The referenced doc lists the scopes required for getting identity/profile information. You can simply add additional scopes to the string, comma-delimited in order to request access to other APIs. The resulting access token will access both the APIs and identity information (via the UserInfo API endpoint mentioned).</p> <p>That said, what you're trying to do with OpenID 2.0/OAuth 1 hybrid should work-- and the user should see a checkbox for "remembering" the authorization. If you really want to debug this further, it'd be helpful to have a webpage you can point to which kicks off this authentication+authorization flow so we can see what's happening.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow can I use Google's OpenID and/or OAuth services to login and allow access to APIs with only ever one prompt to the user?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USRyan Boyd
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow can I use Google's OpenID and/or OAuth services to login and allow access to APIs with only ever one prompt to the user?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThank you! With OAuth 2.0, I haven't so far found out how to identify whether the user has an active session with Google or not and if he does, what his active session id (a "claimed_id" or unique Google id) is, without ever showing him anything. This is necessary because I need to see if he has an active account with us when he goes to log in, and if he does, to ensure his account doesn't get "re-created" in our database every time he logs in. I still want to store data related to his account locally somehow on my database server. (character limit..I'll have to comment twice.)
      singulars
      1. PO
      1. USAndy Matteson
    2. COAnd I have seen that page, and have implemented some aspects of OAuth 2.0 (I guess just API access) into my site, but I have some concerns about this. It seems like identity and API authorization can't be done "concurrently to the user" (one prompt total) with OAuth 2.0, which I'm assuming was the whole motive for the Hybrid approach, or am I wrong? I have read through almost every page on Google's Dev docs and I'm still confused because I don't have practical experience with this.
      singulars
      1. PO
      1. USAndy Matteson
    3. COYes, you can get access to both identity and additional information (such as YouTube videos, contacts, Google Drive) in 1 prompt in the user's lifetime. You simply specify the multiple scopes you need. The user will be prompted the first time you request access to their info, and only the first time. Of course, you won't get their unique Google ID until after they've approved the request the first-time. But on subsequent requests, it'll be a redirect to Google, then an immediate redirect back to your app with either an authorization code or an access token (depending on flow you choose).
      singulars
      1. PO
      1. USRyan Boyd
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload