▪ The same string cannot be used both as a user name and a role name.
▪ After a user role is granted, the role takes effect when the user who is granted the role logs on to the database. If the user is already logged on to the database when the role is granted, the role takes effect when the user disconnects and then reconnects to the database.