I'm very new to Cognos, so I'm likely making a basic mistake....
I'm trying to grant permission to users from AD. When I add them under Security -> Cognos -> Authentication Groups -> COGNOS_BUSINESS_AUTHOR, the user can login.
Looking at the SQL Server database, I see that cmobjprops33 has lots of users, but not the new ones I'm trying to add. How do I get it to add the users to cmobjprops33? I ask this because I see several stored procedures that reference cmobjprops33.
Being "very new to Cognos", I suggest not worrying about content manager tables and Cognos stored procedures. In fact, most people need never even so much as look at the CM database.
You have much bigger fish to fry.