Why do you want user-A to create view in user-B ? Any specific reason ? If user-B can select table from user-A, user-B can create view right ? (Assuming User-B has privileges to create view). Am I missing something here ?